CODEWITHSUNDEEP
sqlsql-servert-sqlreporting-services
Alex Gordon
Alex Gordon

Reputation: 60912

is it possible to customize values for parameters in SSRS subscriptions?

I have an SSRS 2008 report where the default parameters values are this:

<ReportParameter Name="BegDate">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=DateAdd("D",-13,DateAdd("D",6-(Weekday(Today)),Today))</Value>
        </Values>
      </DefaultValue>
      <Prompt>BegDate</Prompt>
    </ReportParameter>
    <ReportParameter Name="EndDate">
      <DataType>DateTime</DataType>
      <DefaultValue>
        <Values>
          <Value>=DateAdd("D",-7,DateAdd("D",6-(Weekday(Today)),Today))</Value>
        </Values>
      </DefaultValue>

I am trying to create a subscription to this report, but pass different parameter values in here:

enter image description here

How can I do this? Can I enter formulas in those textboxes?

Upvotes: 2

Views: 502

Answers (1)

RandomUs1r
RandomUs1r

Reputation: 4188

You need data driven subscriptions: found exclusively in the enterprise edition of SQL server:

http://msdn.microsoft.com/en-us/library/ms159150.aspx

I worked for a company previous that didn't have the funds (ehm... was too cheap) to get the enterprise edition. I wound up writing a pretty cool windows service that authenticated against SSRS and then sent out reports using this technique:

http://msdn.microsoft.com/en-us/library/ms155391.aspx

Upvotes: 3

Related Questions