Calendar days as input value to start and end dates


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.
LVL 15
Faiga DiegelSr Database EngineerAsked:
Who is Participating?
 
ThorSG1Commented:
If you are using a stored procedure you can use datediff and not have to pass the date range at all.  Use books online or post back if you need more help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.