Post reply

SQL Server Reporting Services

  • April 5, 2006 at 9:18 am

    #171831

    I have a SSRS report that needs to be executed and distributed monthly.  I would like to set up a subscription for this report with a schedule to run it monthly.  Does anyone know how to set the parameters (start date and end date) to be ade dynamic so that they change every month?

  • April 6, 2006 at 9:06 am

    #631258

    Hello Wayne,

    The way I do it is to call a stored proc that has two date parameters specified as output parameters.  You can determine the date logic in your proc to return the dates needed for monthly processing.  Once you have this setup, you can call this proc for any report you need on a scheduled basis.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply