COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Upgrading to Cognos 10 => Topic started by: nishant.thakar on 13 Aug 2012 08:24:26 PM

Title: Running Upgraded Report: Report promptin paramenter on default prompt page
Post by: nishant.thakar on 13 Aug 2012 08:24:26 PM
Hi,
I have upgraded the report now while running the report, the report is prompting for value on default prompt page instead of prompt page created for prompts.
Please help.

Regards,
Nishant
Title: Re: Running Upgraded Report: Report promptin paramenter on default prompt page
Post by: tjohnson3050 on 13 Aug 2012 09:59:02 PM
The default prompt page is displayed when there is a parameter in the report definition that is not referenced by a prompt.
Title: Re: Running Upgraded Report: Report promptin paramenter on default prompt page
Post by: nishant.thakar on 13 Aug 2012 10:23:25 PM
Thanks Johnson for your reply.
But the parameter for which report is prompting is a valid parameter.
Title: Re: Running Upgraded Report: Report promptin paramenter on default prompt page
Post by: tjohnson3050 on 14 Aug 2012 10:23:04 AM
In order to display the prompt page that you created, Cognos needs to satisfy any parameter that is in any query referenced by your prompt page.  I have usually found this issue when a query I am using to populate a prompt has a parameter in it.  Cognos needs to satisfy that parameter first before displaying the prompt page that was developed.  To correct the issue, first identify the paramter in question and find out where it is used.  Then you can either make the parameter optional, or remove it.

You can make a parameter optional by setting the usage property on a filter (if that's where it is) to optional, or replace the paramater with a prompt macro that supplies a default value:

For example, replace:
?Country?

With:
#prompt('Country','text','USA')#