i have 2 independent flags: A & B used as list box selections on screen, users can choose A or/and B to see different issues. without selection, user can see everything. i have trouble to let user to select the 2 flags and get records with either/or issues.
*i have 10 flags in my report. this is for a issue identification report, each record can have many different issues, each flag could act as a filter... how do i do a "OR" selection?
prod site flag A flag B
123 P 1 0
xxx Y 0 1
uys O 1 1
777 T 0 0
if i select A=1, then reco 1,3 appear
if i select B=1, then reco 2,3 appear
if i select A=1, B=1, then reco 3 appears
How do i get 1,2,3 to appear by select on both A and B list box?
Can you have 2 list boxes? If so you can control with 2 alternate states. In the expression, you can choose to use the alternate state to suit your needs. e.g. in your 3rd condition you can use the union of the 2 alternate states.
but I have more than 10 flags in my report, an user can potentially choose flag 1,3, 6, 9, 11 or flag 2,8 or flag 4, 5,12... the combination is pretty much endless. i can't really create a separate list box for each combination, that's too many
