COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gats1527 on 22 Jun 2010 03:34:53 PM

Title: Prompt based on Fact Item for Months
Post by: gats1527 on 22 Jun 2010 03:34:53 PM
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
Title: Re: Prompt based on Fact Item for Months
Post by: blom0344 on 23 Jun 2010 03:43:55 AM
One way would be to add all dataitems to a list and conditionally hide/show the columns based on the prompt values chosen
Title: Re: Prompt based on Fact Item for Months
Post by: gats1527 on 23 Jun 2010 07:10:48 AM
How would the prompt page be created if each of the months are a seperate column in a list report?
Title: Re: Prompt based on Fact Item for Months
Post by: blom0344 on 23 Jun 2010 09:19:33 AM
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..