Calendar days as input value to start and end dates

Posted on 2009-04-23
Last Modified: 2012-05-06

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.
Question by:faiga16
    1 Comment
    LVL 4

    Accepted 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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now