Monday 24 July 2017

SSRS: Standard Subscriptions

In Standard Subscriptions, we can pass the static values (We cannot change the value during "Run time/Pragmatically") only. Values are Parameters/Share File path/Recipient list/Mail Priority/Render type etc. During run-time it will take static values to deliver the report. We need to edit the subscription in case of any value which we need to changes.

Steps to Create Standard Subscriptions:

  • Connect to the Report Manager and mouse over on the required report then open menu "down arrow" will enable, click on it. Select the "Manage" option.
  • Manage window will open, then click on "Subscript" section. Once we are in Subscripts tab click on "New Subscriptions" (highlighted in the below screen).
  • Once we click on "New Subscriptions", Subscriptions window will open. In this example i am going to choose "E-Mail" as deliver option. Enter recipient list, Report Output type, Priority and Comment details. After that click on "Select Schedule" button to schedule the report delivery.
  • Choose the scheduling details and click on "OK" button.
  • The report "BalanceDetails" in this example is having tow parameters, so we need to enter the parameter values and click on "OK" button.
  • Now we can see the "Report Subscription" in the "Subscriptions section.

No comments:

Post a Comment