View in Report

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  August 12, 2015 at 10:37 am

  #320627

  Is there a way to figure out all the reports on reportserver that use a particular view?

  I am trying to get rid of the view but need to make sure nothing is dependent on it .

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  August 12, 2015 at 11:12 am

  #1819438

  Exercise your googlefu!

  http://blog.sqlauthority.com/2010/02/04/sql-server-get-the-list-of-object-dependencies-sp_depends-and-information_schema-routines-and-sys-dm_sql_referencing_entities/

  and dig around on sqlauthority... it's probably on there.

• HS_12

  Old Hand

  Points: 382

  More actions

  August 27, 2015 at 9:15 am

  #1822806

  Detail information of reports deployed in report server are stored in report server database catalog table, you can query data source, dataset, parameters and so on in this table. Sample query for your reference:

  Listing all Data Sources and their Dependencies (reports, items, etc) in SQL Server 2008 R2

  Get SSRS Report Information