Need help reporting on rebort builder metadata RRS feed

  • Question

  • HI there,

    I am hoping to populate  a table that we use for documenting reports programmatically for old legacy report,

    the info I would like to retrieve and populate for each report (report builder 3) is  :-

    1 Fields included on the report 
    2 Sort criteria - must have
    3 Filters used - must have
    4 Grouping - must have
    5 Data sources (have found some code that may do this)

    The plan is to auto populate a table  and then maybe manually edit it , I hate data entry when so much data is stored as metadata, any scripts or help you can offer me would be awesome.

    cheers, rob

    Friday, August 10, 2012 7:23 AM


  • Hi Diese111,

    Thanks for your posting.

    In your case, I think that you can look into report parts in Reporting Services. Report parts are self-contained report items that are stored on the report server, we can save a report part with its dependent datasets and shared data source references so it can be reused in other reports.

    For more information, please refer to the articles below:
    Report Parts and Datasets in Report Builder: http://technet.microsoft.com/en-us/library/ee633649.aspx
    Managing Report Parts: http://technet.microsoft.com/en-us/library/ee636148.aspx

    Bin Long

    Bin Long

    TechNet Community Support

    • Proposed as answer by Elvis Long Friday, August 17, 2012 5:10 AM
    • Marked as answer by Elvis Long Sunday, August 19, 2012 2:52 PM
    Thursday, August 16, 2012 4:58 AM

All replies