COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: jd on 16 Aug 2011 11:41:59 AM

Title: Date Prompts
Post by: jd on 16 Aug 2011 11:41:59 AM
Hi friends,

I have report with Begin Date and End Date prompts.
my filter is date between?startdate? and ?enddate?( I am fine so far)

If the dates range is not entered with user, default the date entries to: "system date minus 12 months and system date"
how can I achive this part..

Thanks,
Title: Re: Date Prompts
Post by: saumil287 on 17 Aug 2011 12:06:05 AM
Hi
Click on the set properties icon under the cognos connection either in public folders or my folders where u saved your reports where u are having white colored icon with a finger pointing hand,  On Click on that, u will get 3 tabs as General,Reports and permissions.
Click on reports tab, u will find the following
prompt values:
No values saved
Set

click on set link to set the default values of the prompts in your report then click on OK.
Title: Re: Date Prompts
Post by: chaithucognos007 on 18 Aug 2011 02:09:14 PM
Hi Saumil... what you said is for particular dates(i mean static dates)....right ?,
where as Laxmi wants the default values to be dynamic( "system date minus 12 months and system date") .... may be we should try something different ???