BusinessObjects Board

Two Filters, One Prompt

Hi to all

I have A question :roll_eyes: I need to do this in my report

when i click refresh, a prompt appears and ask me for the the condition i want, I should select C1 or C2, if C1 selected it will insert a filters to the report such as (F1 [Col1 = 0 And Col2 >5]), if C2 select it will insert different filter (F2 [Col1 < 9 Or Col2 =0])

So can any one tell me how to do it? do i need to do two filters or only one with prompt?? :roll_eyes:

I have BO XI R2 SP3


DataAdmin :bahrain: (BOB member since 2006-08-23)

For DeskI only, check the following link:

How to Show/Hide report blocks on user selection


BO_Chief :us: (BOB member since 2004-06-06)

Hi BO_Chief,

Thanks, but i need to do it in the designer so the user only drag and drop the filter to the report and it will prompt him to select between two condition each one with a different filter, any idea?


DataAdmin :bahrain: (BOB member since 2006-08-23)

Create a prompt with this type of logic


((@prompt('Select C1/C2?','A',{'C1','C2'},mono,constrained)='C1' and  (F1 [Col1 = 0 And Col2 >5])) or 
(@prompt('Select C1/C2?','A',{'C1','C2'},mono,constrained)='C2' and (F2 [Col1 < 9 Or Col2 =0]))) 

AnthonyJ :philippines: (BOB member since 2006-06-30)

Thanks , its work :wave: :wave:


DataAdmin :bahrain: (BOB member since 2006-08-23)