Data Driven Subscription - Where is the data source of the dataset stored?

• Pete Bishop

  Ten Centuries

  Points: 1339

  More actions

  April 22, 2022 at 12:58 pm

  Go to Answer

  #4020476

  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.

• Gerckens.3

  Newbie

  Points: 2

  More actions

  April 22, 2022 at 3:45 pm

  Answer

  #4020574

  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

  "The Bible tells us to love our neighbors, and also to love our enemies; probably because they are generally the same people." G. K. Chesterton

• April 22, 2022 at 6:12 pm

  This was removed by the editor as SPAM