Results 1 to 2 of 2

Thread: setting a data-driven subscription in SSRS

  1. #1
    Join Date
    Aug 2012
    Posts
    10

    setting a data-driven subscription in SSRS

    I am setting a data-driven subscription in SSRS with what I hope to be a parameter for a date/time variable. The business requirement is that I pass a Parmenter to the report that needs to be set to yesterday's date from when the subscribed email alert is sent.

    This is a query I am using in a data-driven subscription in SSRS. How to I make the following SQL query return the previous date instead of the current system date:
    Code:
        SELECT CONVERT (date, SYSDATETIME()) as rundate

  2. #2
    Join Date
    Aug 2012
    Posts
    10
    Quote Originally Posted by Complete View Post
    I am setting a data-driven subscription in SSRS with what I hope to be a parameter for a date/time variable. The business requirement is that I pass a Parmenter to the report that needs to be set to yesterday's date from when the subscribed email alert is sent.

    This is a query I am using in a data-driven subscription in SSRS. How to I make the following SQL query return the previous date instead of the current system date:
    Code:
        SELECT CONVERT (date, SYSDATETIME()) as rundate
    Code:
    SELECT convert (date, DATEADD (DAY, -1 , SYSDATETIME())) as rundate

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •