Post reply

2 subscriptions for same report, having different @startdate @enddate default values

  • August 23, 2014 at 6:29 pm

    #298706

    Hi,

    I have an SSRS report that has @startdate and @enddate parameters.

    I want to email this report every day an end consumer, however, Mondays report needs to return 2 days worth of values, whereas, every other business day, only 1 days worth of values.

    Is there a way to send values for SSRS parameters from the SSRS subscription interface? That way I can have two subscriptions, one for Mondays only, and one for Tue, Wed, Thu, Fri, that pass different values for the same two parameters, so that I reuse the same SSRS report for them both? I want it to be transparent to the end consumer that I am actually using two subscriptions for the same report. As far as he's concerned my method is smart enough to know it's Monday:-)

    How do you specify the value of a parameter from the subscription on the report server?

    --Quote me

  • August 23, 2014 at 7:24 pm

    #1740527

    This link had the solution

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/535c7e0a-75e2-47d0-8b18-60d1e94805a2/setting-variable-parameters-in-a-ssrs-subscription

    --Quote me

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

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