Controlling filters using prompts

[phoenixfire]

Hi Everyone,
I have a question. Is it possible to control the filters you use in a report using prompts?
For eg. Say a report has 10 filters. Is it possible to control these filters using a value prompt with multi-select option turned on?
So end result would be, you get to choose the filters you would like to be applied in the report.

The discussion came up at work and I have never heard of anything like this. Didn't even think it possible to implement this type of functionality. But has anyone come across something like this or know about this feature?

Any info is appreciated. Just looking to exchange ideas here.

Thanks in advance.

[ajju B]

Use a promptmany() macro in a filter expression which utilizes a prompt parameter that is set to a static value.