If you are unable to create a new account, please email support@bspsoftware.com

 

Running Upgraded Report: Report promptin paramenter on default prompt page

Started by nishant.thakar, 13 Aug 2012 08:24:26 PM

Previous topic - Next topic

nishant.thakar

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

tjohnson3050

The default prompt page is displayed when there is a parameter in the report definition that is not referenced by a prompt.

nishant.thakar

Thanks Johnson for your reply.
But the parameter for which report is prompting is a valid parameter.

tjohnson3050

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')#