We recently upgraded from SQL SSRS 2008 R2 Sharepoint 2010 Integration Mode to SQL SSRS 2010 Sharepoint 2010 Integration Mode. After making this upgrade we were no longer able to edit any of the Data Driven subscriptions. The reason for this is that SSRS 2010 Data Driven subscriptions require a few additional nodes than 2008 R2. If you edit the subscriptions in the ReportServer.dbo.Subscriptions table you will be able to edit via the SharePoint/ReportServer UI.
F Follow the below steps and script.
1. Find
the SubscriptionID
2. Update
the SubscriptionID variable
3. Run
the Subscription update
4. Edit
the Subscription in SharePoint to confirm
Due to formatting I had to upload the script in a file:
http://fsugeiger.com/misc/codesamples/sqlssrssubscriptionfix.txt
2 comments:
Post a Comment