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

Default prompt values (with no prompt page)

Started by richard@AA, 19 Apr 2012 02:50:21 PM

Previous topic - Next topic

richard@AA

I have a requirement NOT to have a prompt page. I will have two date value prompts (not date prompts) for start and end date on the report page and a refresh/reprompt button. They will be populated with all of the dates (month and year with day suppressed) from a table. They want the report to display with the most current month as the end date and 13 months prior for the start date when the report is initially run and then be able to change the dates. I have a query subject with these default dates built in FM. My issues are:

How do I NOT have a prompt page for the filters (Cognos keeps giving me one even when the prompt and filters are optional/not required)?

How can I dynamically have the value prompts default to the default dates?

bnbushan

Default the prompt parameters ...go and select prompts and ....from the properties ..set default values...that will not ask u prompt page...

kalyan_y

Instead of having prompts on a prompt page, place them on the report page, set 'Autosubmit' to Yes for the prompts and delete the prompt page.
Default the values in the prompts such that the report picks up the data as required when the report is run for the first time. Later on, you can change the prompt values and the report refreshes itself.

richard@AA

How do I set the prompts to a value that can change? I have a data Items from a query that will have the correct value, but I don't know how to set the prompt. As for setting the prompt to auto submit, they do not want them to auto submit since they could want an completly different date range and when they change the start date the page would refresh. thanks what else can we do?

richard@AA

I was working this issue on two forums. I got the answer in the other one (http://it.toolbox.com/msg-status/30439) ...thanks everyone.

Chau-BSDSolution

#5
Hi everyone  :D

- I tried created two param in page cognos ?fromdate? and ?todate?. But When I run report ,  param display in prompt page.  I delete prompt page.
- how to make ????