COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: annareddy on 29 Feb 2012 04:04:32 AM

Title: Scheduling issue with two date prompts
Post by: annareddy on 29 Feb 2012 04:04:32 AM
HI,

I want to schedule the report with two date prompst (start and end date) it will filter the past seven days data when report is executed.
date prompts should not have any default dates, it should take current date and should get past seven days data, so we can not give default date to the prompt.

if we did not give default value then report is not scheduling accordingly.

Please give your inputs.

Thanks in advance,
Annareddy
Title: Re: Scheduling issue with two date prompts
Post by: blom0344 on 29 Feb 2012 07:43:06 AM
Are you sure you need prompts anyway? It looks like you could use a simple filter based on the current_date for data retrieval..
Title: Re: Scheduling issue with two date prompts
Post by: Grim on 29 Feb 2012 07:56:39 AM
Here ya go:
https://www-304.ibm.com/support/docview.wss?uid=swg21341904

Start with that then filter your report for current date -7 days.
Title: Re: Scheduling issue with two date prompts
Post by: blom0344 on 29 Feb 2012 08:46:13 AM
Grim,

Why are you notifying this post to moderators?
Title: Re: Scheduling issue with two date prompts
Post by: Grim on 29 Feb 2012 12:19:14 PM
Quote from: blom0344 on 29 Feb 2012 08:46:13 AM
Grim,

Why are you notifying this post to moderators?

I was actually trying to report:
http://www.cognoise.com/community/index.php/topic,18625.msg54981.html#msg54981

Which is a dupe of this thread.