Subscriptions in SQL Reporting Services

Posted on 2007-07-23
Last Modified: 2012-08-14

I am new to SQL Server Reporting Services and i need to accomplish the following:

Email a report via subscription on the 1st of every month that would send the details of last month's report.

Example - Medical records to be sent out on 1st of August that would report on the details on the previous month (July).

Hope you can help.
Question by:SigmundFraud
    LVL 1

    Accepted Solution

    look here how to create a subscription that runs every first day of the month:
    change the query in your report to something like this:
    select *
    from table
    where date between dateadd(m,-1,getdate()) and dateadd(d,-1,getdate())

    this query selects all data where de date-field "date" lies between yesterday and a month earlier

    Author Comment

    Works great.

    Thanks for the swift reply.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    758 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

    12 Experts available now in Live!

    Get 1:1 Help Now