COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nigew on 03 Dec 2014 04:00:17 AM

Title: A report to just select the last weeks sales
Post by: nigew on 03 Dec 2014 04:00:17 AM
Hi All

I currently have a report that has date prompts ?from? and ?to?

How could i make the report pick up the last weeks sales for a burst report?

in effect just showing the last 7 days

Many thanks

Title: Re: A report to just select the last weeks sales
Post by: BigChris on 03 Dec 2014 04:21:54 AM
I need to do this quite a lot, and because I don't like writing code again and again I've saved it in a blog:

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

Take a look and let me know if any of it doesn't make sense.
Title: Re: A report to just select the last weeks sales
Post by: nigew on 03 Dec 2014 04:41:42 AM
Many thanks

Thats sorted it
Title: Re: A report to just select the last weeks sales
Post by: MFGF on 04 Dec 2014 11:15:53 AM
Quote from: BigChris on 03 Dec 2014 04:21:54 AM
I need to do this quite a lot, and because I don't like writing code again and again I've saved it in a blog:

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

Take a look and let me know if any of it doesn't make sense.

That earns an applaud from me! :)
Title: Re: A report to just select the last weeks sales
Post by: BigChris on 05 Dec 2014 02:05:59 AM
You're too kind!