Hi ,
I have a report that receives the filter date from a calendar that the user can select.
The problem is that i want to send via email that report in a automatic way . I want to set the parameter the actual date , how can i fix the calendar parameter? Do i have to drop the calendar and change the parameters?
The perfect solution would be to make teh calendar take a default value (actual date) if the report executes automatically.
thanks in advance.
I use this approach so much that I wrote a blog post about it :)
http://cognostips.weebly.com/blog/date-prompts (http://cognostips.weebly.com/blog/date-prompts)
I feel this is different that what i am looking for.
I need to pass the actual date to the Pdate parameter of teh calendar.
Hoy can i assign a getdate() value to the parameter that manages the calendar?
Thanks in advance.
The easiest way would be to modify the prompts in the queries to use a prompt macro instead of a prompt alias. Then you can do something like:
[Namespace].[Time Dim].[Date] = #prompt('p_Date','date','getDate()')#
if the p_Date parameter is null, it will default to getDate().
Thank you very much.
It works!!! Thanks CognosPaul!