Prompt based on Fact Item for Months

[gats1527]

We have a report with 12 fact items for the 12 months of a year and we would like to have a prompt set up so the users can select which months to pull data for. Any assistance will be appreciated.

Thanks

Tom

[blom0344]

One way would be to add all dataitems to a list and conditionally hide/show the columns based on the prompt values chosen

[gats1527]

How would the prompt page be created if each of the months are a seperate column in a list report?

[blom0344]

Instead of associating a query with the prompt try to create a fixed selection (12 values) with a valueprompt (parameter = 'parameter_prompt') and multiple selections set to yes.
Suppose you designate the monthnumber 1,2,3,4,...,12 as selection , then it would be a matter of creating 12 boolean variables like:

ParamValue('parameter_prompt') contains '1'  to show/hide the first column in the list..