1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

data-driven subscription in SSRS

Discussion in 'SQL Server' started by Xarzu, Feb 12, 2019 at 12:04 AM.

  1. Xarzu

    Xarzu New Member

    Joined:
    Dec 18, 2007
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    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:

    SELECT CONVERT (date, SYSDATETIME()) as rundate
     
  2. Xarzu

    Xarzu New Member

    Joined:
    Dec 18, 2007
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    SELECT convert (date, DATEADD (DAY, -1 , SYSDATETIME())) as rundate
     

Share This Page