Reporting Services Data Driven Subscriptions on SharePoint Integrated Mode


 

I have seen in the forums that the people used to the SQL Server Reporting Services (SSRS) Native mode are having issues to find the Data Driven Subscriptions options when they are using the SharePoint Integrated Mode.

The first thing you need to verify is that you are using a Enterprise or Developer version of SSRS , because the Data Driven Subscriptions are only available on those versions.

Let me show you a step by step guide to create the Data Driven Subscriptions in SharePoint Integrated Mode with Screenshots

1. Navigate to the report you want to create the subscription and Click on the SharePoint Dropdown list and select Manage Subscriptions

image

2. The manage subscriptions page will show , click on the Add Data-Driven Subscription option

 

image

 

3. The Step 1 of the Wizard for Data Driven Subscriptions will show, now fill out the fields with the information (if you need more details about Data Driven Subscriptions visit http://msdn.microsoft.com/en-us/library/ms156012.aspx)

image

4. Click on validate to ensure everything is correct , and click next, the Step 2 of the Wizard will show, this is the place to define the parameters of the report (my example does not have any so it is empty) click next

image

5. The Step 3 of the Wizard will show, this step requires all the Delivery options of the report, fill out the fields and click on next

 

image

 

6. Finally is the Step 4 to define the Schedule, fill out the values and click Finish

 

image

7. The Subscription will show in the List of Subscriptions, with the information about the Last Run and Last Results

image

I hope this screenshots helps to become more familiar with Data Driven Subscriptions in SharePoint Mode

Comments (5)

  1. ...But what if the Manage Items are not in my report options says:

    I can't find anywhere how to address the issue that my deployed reports do not have the Manage options on my drop down list. report work fine and I can do a manual run no issue or subscribe off the actions list above the manual run area of the report.

  2. ..Oh and I do have enterprise edition installed. says:

    From what I can tell that is the only verion I have installed. it is 2008 R2 enterprise

  3. Jaime Tarquino says:

    Try to enable the RS feature.

    In your site select Site Actions, Site Settings

    Select the option Site collection features (under Site Collection Administration)

    Look for Report Server Integration Feature and click in Activate

  4. Jing says:

    Hi there,

    My data driven subscriptions always fails…..i have no idea why….

  5. Jaime Tarquino says:

    You can try some of the recommendations for troubleshooting from my friend Dean blog blogs.msdn.com/…/diagnosing-and-troubleshooting-subscriptions.aspx