Post reply

SSRS and Data Sources

  • September 14, 2009 at 9:34 am

    #385354

    Does anyone out there know how to query the reports server database and find all reports by name and what data source they have attached to them.

    Any help would be greatly appreciated. I have 315 reports I have to set data sources on and it's taking a huge amount of time to update the data sources on a new server (have to do this twice).

    Thanks

  • September 14, 2009 at 12:27 pm

    #1053378

    this should at least get you started

    select * from catalog c inner join datasource d on

    c.itemid = d.itemid

  • September 14, 2009 at 12:41 pm

    #1053389

    For the most part that works, but I can't determine the shared datasource name on each report. Any thoughts

  • September 14, 2009 at 1:20 pm

    #1053417

    select c.name as reportname, d.name as datasourcename from catalog c inner join datasource d on

    c.itemid = d.itemid

    you will have multiple rows per report if you use more than one datasource in any reports.

  • July 14, 2010 at 7:25 pm

    #1193211

    There is an application (SSRS Data Source Manager) that can fix missing data sources, and change current data sources for RDL reports and models. It can be used to change a single report / model or allow bulk changes for many reports and models.

    There is also a health check feature, to detect and correct reports and models that have missing data sources. Multiple data sources for reports and models are also supported.

    http://www.lecomputing.com/ssrsdatasourcemanager.html

    Other uses can be- changing a selection of reports to another data source, eg moving from UAT/Development to production, or server loading issues.

  • July 27, 2010 at 12:42 pm

    #1198907

    Adam Angelini (9/14/2009)

    select c.name as reportname, d.name as datasourcename from catalog c inner join datasource d on

    c.itemid = d.itemid

    you will have multiple rows per report if you use more than one datasource in any reports.

    Thanks Adam! This is exactly what I needed!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply