BusinessObjects Board

Filtering on Y, N or Y and N

building reports webintelligence
#1

Sorry, I have a real easy question for someone. I have a column with Y and N values and I want to filter on
Y
N
or Y and N

can get the Y or N to query ok but not sure how to get the ‘Y and N’ in a prompt i.e. so the report will give all values of Y and N

bencouve (BOB member since 2006-05-19)

#2

You can check this FAQ for applying a logic for choosing ‘ALL’ values;

https://bobj-board.org/t/15227/2

nithya_raj (BOB member since 2007-02-03)

#3

If i understand you correctly you want to prompt for ‘Y’, ‘N’ and to prompt for all rows that are either ‘Y’ or ‘N’. If so then use in list operator. User can enter values of ‘Y’, ‘N’ or ‘Y;N’ - that is a single Y or N or both Y and N separated by a semicolon.

AL

agulland :uk: (BOB member since 2004-03-17)

#4

Thanks for your comments. Al, if I could get your suggestion of using a semicolon to work then I would be ber happy, however, I cannot seem to get Y;N as an option in the llist. Perhaps I am doing something wrong

bencouve (BOB member since 2006-05-19)

#5

Ok, I got AL’s suggestion to work. The condition must be set to ‘in list’ and then one can enter Y, N or Y;N

Thanks Al, appreciate the help, and the other chapie

bencouve (BOB member since 2006-05-19)