dianerstein 8713 (10/25/2016)
I have the following 2 questions to ask about a SSRS 2012 data driven subscription:1. On a test report server, I am testing the data driven subscription that I have setup. Everyone time I want to change some value, I hit the edit option and almost everything that was entered previously is lost. Thus is there a way to save what was previously entered? If so, how would I save the values and update them when I need to?
I haven't seen this behavior, other than passwords blanking out and having to be re-entered.
2. The ssrs data driven subscription information is saved in the database somewhere. Can you tell me where this information is saved and how to access this information? I want to be able to save this information in TFS (version control software) if possible.
Subscription info lives in the ReportServer database. Here's a generic query to get you started on the data-driven subscriptions:
USE ReportServer
SELECT c.Name AS Report
, s.Description
,*
FROM dbo.SubscriptionsAS s
INNER JOIN dbo.CatalogAS cON s.Report_OID = c.ItemID
INNER JOIN dbo.ReportScheduleAS RSON S.SubscriptionID = RS.SubscriptionID
INNER JOIN dbo.ScheduleAS ScON RS.ScheduleID = Sc.ScheduleID
WHERE s.DataSettings IS NOT NULL--for data-driven