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?
Default the prompt parameters ...go and select prompts and ....from the properties ..set default values...that will not ask u prompt page...
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.
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?
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.
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 ????