Calendar days as input value to start and end dates
Posted on 2009-04-23
I have a requirement to setup a report subscription using the calendar days as input parameter to the report. The report should run every 1st, 8th, 15th and 22nd of each month. I know how to setup the subscription for calendar days. It's the dynamic range date for my input parameter (start and end date).
On the 8th, the date range should be from 1-7.
On the 15th, date range should be from 8-14.
On the 22nd, date range should be 15-21.
On the 1st, date range should be from 22 upto the last day of each month.
Is there a way to pass these values as my input parameter to my report? I was thinking of creating four subscriptions but still can't figure out how to make the above subscription scenarios.
Any suggestions experts?
I'm using SQL 2005 Standard Ed, SSRS 2005.