COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bloggerman on 04 Jul 2012 03:11:58 PM

Title: Prompt on report page
Post by: bloggerman on 04 Jul 2012 03:11:58 PM
I need to set a prompt on the report page itself and not on the prompt page. Is it mandatory to have it set to optional. If i have it as required I get prompted to choose a value even before i reach the report page
Title: Re: Prompt on report page
Post by: jmills on 04 Jul 2012 03:29:14 PM
You can set a prompt on the report page, and no, it is not necessary for it to be mandatory.

Ensure that the prompt in your filter is set to 'Optional' in the Properties of Query Explorer, along with the Prompt Value (ie. Text Box/Value prompt).
Title: Re: Prompt on report page
Post by: bloggerman on 07 Jul 2012 12:17:07 AM
I meant can i have the prompt as mandatory?

Also, on a different topic, what happens if i set the filter to optional int the query explorer  but have the prompt in the page explorer to required.
Title: Re: Prompt on report page
Post by: CoolP on 09 Jul 2012 05:31:32 AM
The setting that you define in the filter(optional, mandatory) overrides the setting on the prompt control. You can have the mandatory prompt on the report page (depends on your requirement).


Thanks
Prasan
Title: Re: Prompt on report page
Post by: mtirpude on 25 Oct 2012 03:28:49 AM
Hi,

When you have a prompt on your report page and you dont want it to be prompted before the main page loads, the prompt should be optional. You need to set default value of the prompt using properties pane by clicking on the prompt. This default value is picked by the prompt when report runs first time. Though you can change this default value when main page loads.

Regards,
Manish | +919673990644
www.infocepts.com | mtirpude@infocepts.com