Print Page - How to schedule a report with dynamic dates

Title: How to schedule a report with dynamic dates
Post by: kirru_alayam@yahoo.co.in on 15 Mar 2017 06:48:25 AM

Hi All,

The prompt page is having two date fields (StartDate and EndDate). And When I run the report StartDate will be displayed '1 Jan 2017' and EndDate will be displayed yesterday date in the prompt page.

Now, we have a requirement like if we schedule a report it should run for last month.

For example, If I schedule a report today (March 15, 2017), the report should run for the last month from 1st February 2017 to 28th February 2017 and should not ask to select the prompt values again.

Could you please help me on this requirement.

Thanks,
Kiran

Title: Re: How to schedule a report with dynamic dates
Post by: BigChris on 15 Mar 2017 07:21:43 AM

This is something I use quite a lot - in fact I wrote a blog post so that I can find it when I need it:

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kirru_alayam@yahoo.co.in on 15 Mar 2017 06:48:25 AM