Conditional Filter

[dferrara]

I would like to conditionally control a filter in a report in report studio. Is there away that I can mark a filter optional and then based on a conditional statement determine if the filter will be used or now?

In my case I would like to use the filter based on what the current session group is. If it is group A enable the filter else disable the filter.
Thanks for your help.

[tupac_rd]

I think you can add the group level condition in your filter itself.

[dferrara]

I would be intersted in hear more how to do this.

[tupac_rd]

I am assuming this is for a Report studio report.

add a query calculation in the report query called "Group Name" with the following expression #sq(csv(CAMIDListForType('group')))#

Then your filter would include

if ([Group Name] = 'Group A') then (1=1) else ([Data Item] = ?prompt?)

instead of just

[Data Item] = ?prompt? which I guess you have right now.

HTH
2pac

[dferrara]

Great! thanks