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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Very Urgent : extra prompt window while running the report

Started by Nandini.t, 20 Oct 2011 06:56:23 AM

Previous topic - Next topic

Nandini.t

i have created a prompt window of 3 prompts (branch,Analysis year and policy number) but, while running the report an extra prompt page which is asking for analysis year alone before going to the prompt window which is created.

Note : i used analysis year parameter in one of my filter condition.if i remove that filter i am not getting that extra prompt page but the filter is must needed cant delete it.

so please guide me how to overcome this issue.


Arpitagrawal9

Can you check the parameter name of year prompt and the the query where you used the filter

cognostechie

Also check if the filter is 'required' or 'optional'.

brandi

Make sure there is not an extra parameter referenced in the queries.

Also, as someone mentioned, if the prompt is defined as 'Optional' make sure the filters is 'Optional'. Same for Required.

Ras_MA

The other posts have hit the mark but this might help explain what's going on ...

The extra prompt page is a 'friendly error message' indicating that your Analysis Year parameter is not being catered for by either the prompt page or the report query.  This is causing a 'gap' in the code gerenated by the report query which throws the extra prompt page.

So why isn't the gap being filled?  Three common reasons are:

  • An extra parameter - caused by a misspelling between the parameter in your filter and the parameter selected in the prompt control (yours is on the prompt page).

    • These must be identical
    • Parameter names are case and space sensitive
    • Any difference will result in two parameters
    • Check the spelling of the parameter in the extra prompt page and compare it to the the parameter in your filter
  • A conflict in the optional/require settings defined for the parameter.

    • Check this setting for the prompt object and the filter in your report query
    • These must match
  • An obsolete parameter.

    • Check the spelling of the parameter referenced in the extra prompt page
    • Copy your report to clipboard, paste into notepad then search to find out where the obsolete parameter is being referenced in your report.

Possible causes to your particular problema are points 1 and 2.

HTH  :)