set parameter with default value (calendar)

[sergiord2016]

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.

[BigChris]

I use this approach so much that I wrote a blog post about it :)

http://cognostips.weebly.com/blog/date-prompts

[sergiord2016]

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.

[CognosPaul]

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().

[sergiord2016]

Thank you very much.

It works!!! Thanks CognosPaul!