Post reply

SSRS - Grep for SP name used in reports

  • February 23, 2012 at 4:14 pm

    #391638

    if I have access to all the reports in the an SSRS installation how can I get a list of all the reports that use a particular stored procedure in retrieving their data sets. I don't have a repository of all the RDL's. If I did, then I could just grep across that to get what I need. Is there a way to do it without extracting all the reports to RDL's?

    (I'm not familiar with this forum or its structure, so if this post would better appear someplace else, please let me know..)

  • February 23, 2012 at 4:21 pm

    #1451145

    Unless you are using shared datasets, it looks like you will need to get that info by extracting the xml for each report and querying the xml.

    Here is a blog post on extracting the xml (this is part 2 but it links to part 1)

    http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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