Reporting Services

Posted on 2008-11-14
Last Modified: 2012-05-05
Is there a way of getting the list of all tables , sproc and the fields used in indivdual reports on teh live server. i have many reports and doing it manually is time consuming
please help!
Question by:netra26
    LVL 9

    Accepted Solution

    Did you try using SSRS SOAP API (VB.NET or C#)
    here is an sample how to use properties from Shervin Shakibi's Blog but you will need get the datasets or get the report definiton and use XML to get your data like
    DataSets /  Fields and  Query CommandText      nodes ...

     ReportingService2005.GetReportDefinition Method

    using System;
    using SoapAPI.ReportService2005;
    class Module1
             public void Main()
                     ReportingService2005 rs = new ReportingService2005();
                     rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
                     rs.Url = "http://Localhost/reportserver/reportservice2005.asmx";
                     Property name = new Property();
                     name.Name = "Name";
                     Property description = new Property();
                     description.Name = "Description";
                     Property[] properties = new Property[2];
                     properties(0) = name;
                     properties(1) = description;
                     try {
                              Property[] returnProperties = rs.GetProperties("/AdventureWorks Sample Reports/Company Sales", properties);
                              Property p;
                              foreach ( p in returnProperties) {
                                       Console.WriteLine((p.Name + ": " + p.Value));
                     catch (Exception e) {
                     finally {

    Open in new window

    LVL 51

    Expert Comment

    by:Mark Wills
    No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

    I will leave the following recommendation for this question in the Cleanup topic area:
       Accept: Ernariash {http:#22961076}

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    EE Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now