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

non-required parameters never display

Started by dfite, 21 Oct 2008 10:50:30 AM

Previous topic - Next topic

dfite

Hi guys - I have a report that has 4 user parameters, although none are actually required.  In report studio the report runs just fine but thru our application the report never displays the user prompt page at all and just runs.  I've run into this before and always had to force the prompt page to display by requiring a parameter value and then using that value somewhere in the report.  In this case, tho, I can't require any values at all, yet I need to give the user the choice.  Any ideas?  Are there any settings to FORCE the prompt page to display?

I am using cognos 1.1, by the way, and I don't think they have many/any of the MRs installed (unfortunately).

imts

I m not sure if v r able to understand what u really want to ask. But if u want to FORCE ur prompt page to display then set the filters created for the prompts value as "Required" then it will always ask for the values.

DanSev

I'm not sure what functionality you have, but if you add a dummy query item to query one which the report is based 'Prompt Show' as the item, and place a require filter in the query on that data item ([Data Item] = ?prompt?) you can put the required prompt on the prompt page with the static choice of 'Prompt Show' and set its default value to prompt show. You can then turn the box type to none or turn visibilty off on that item. It should force the page to stop b/c there is a required prompt (even though it has an acceptable default value, and is incappable of being accessed by end users).

Suraj

Adding a static choice 'All' in the prompt and making it required is another workaround.
You can have 'All' by default and it'll run for all values assuming you filter the query correctly (when All do not filter...)