Hi there,
I'm looking for a solution to set parameter values in Cognos 8 Report Studio without a prompt.
We have a Frameworkmanager model where our querysubjects have filters with prompts for a version of data in our warehouse. (?p_date? between VALID_FROM and VALID_TO)
By default, report studio will show a date prompt when you create a report with data from the querysubject mentioned above.
Is there a way in report studio, to tell the report to always use "current_date" as input for "p_date" without showing a prompt page to the customer?
So the customer runs the report and gets data with "current_date" without being prompted.
Basically its the question whether you can define values for parameters in the report specification to avoid the prompt page.
Building the filter directly with current_date in the fm model is not an option, because we sometimes need another point in time.
Best regards,
Zapp
Hi Zapp,
The current version of support link has a technique that might help you in this respect.
https://www-950.ibm.com/blogs/basupportlink/entry/dynamic_date_selection_in_scheduled_report1?lang=en_gb
Kind Regards
Rob
Hi Rob,
thx for the link, but I guess this will not help in my task. Our customer wishes the promptpage to entirely disappear.
So our endusers run the report and get results without being prompted.
I want to predefine the value for the prompt and make it disappear.
Something like ?p_date? = current_date with regard to my initial post.
Kind regards,
Zapp
Try using a prompt macro in Framework Manager where the default is set to current date.
Then uncheck the "Prompt for values" property for those reports where you don't want to have a prompt page. You can find this property on the "Report" tab of the report properties in Cognos Connection.
Hopefully this is what you're after.