For a data-driven subscription, you define a dataset which returns information that can be used by the report. For that report you have to define a data source. Does anyone know where that information is stored for a specific subscription? If I look in the [dbo].[Subscriptions] table, the [DataSettings] column contains the actual query being run but I cannot track down the data source itself.
Any ideas? Thanks.
Hi Pete - Try this. They sure don't make it intuitive... 🙂
SELECT c2.Name AS ReportName
,s.Description AS SubscriptionbName
,c.Name AS SubscriptionDataSource
,s.DataSettings AS SubscriptionDatasetQuery
,s.Parameters AS SubscriptionDatasetParameters
FROM dbo.Subscriptions AS S
INNER JOIN dbo.DataSource AS DS
ON S.SubscriptionID = DS.SubscriptionID
INNER JOIN dbo.Catalog AS C
ON ds.link = c.ItemID
INNER JOIN dbo.Catalog AS C2
ON s.Report_OID = c2.ItemID
"When it comes to report design and development, I have a list of pet peeves a mile wide. You might think the list would be a mile long, but I like to turn it on its side, sharpen the end, and poke people with it." - Me
April 22, 2022 at 6:12 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply