SSRS Subscription SharePoint Integrated Mode

Subscription option is available on the SSRS report item to allow the run the report automatically. The user need to be logged in as site administrator to create subscription. Follow the steps below

    • Create a document library (named for example “Extracts” to store the report extracts.
    • Click on “Manage Subscriptions” from the drop down options available against the SSRS report item.

ManageSubscri

    • Click on “Add Subscription”.

UpdateFields

    • Update the fields
      • Delivery Extension = SharePoint Document Library
      • Document Library = The document library created in first step.
      • File Name = Name you want to give to the report exported.
      • Output Format = You can choose Excel 2003 or some other formats.
      • Overwrite existing file or create new version of file = Checked
      • Delivery Event
        • Click on “Configure” to create a schedule. Example of a schedule can be At 8:30 a.m. every Thursday.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s