Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 509
  • Last Modified:

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.
Faiga Diegel
Faiga Diegel
1 Solution
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.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now