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??
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?
((@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])))