Skip to Content
0
Former Member
Mar 18, 2013 at 03:02 AM

Add prompt to report

23 Views

Hello:

I want to add a prompt to a web intelligence report and then use that prompt in a formula to determine at what level the data gets rolled up. For example, if the user enters "Daily", then the formula rolls up the data into dates and then I group on that. If they enter "Monthly" then it rolls up into months.

I know I can use fields in the Edit Query window to add prompt filters, but in the case I am not filtering, I just want a value I can pass to the report.

How to do?

Thanks!