Post reply

Extract Tablix column information from Report Server

  • June 18, 2016 at 5:36 am

    #308541

    Hi All,

    For documenting purposes I would like to extract data concerning the reports on the report server.

    Specially all 90% reports only have a single tablix with Header and Detail. I would like to produce a list of each report and the columns in the tabix, header and data srouce field name would be ideal.

    I have seen way to get report names our and even data set but nothing concerning the actual report objects like a tablix.

    is this possible in SSRS 2008 R2

    Thanks

    Steve

  • June 18, 2016 at 9:08 pm

    #1885757

    This might get you started:

    http://bretstateham.com/extracting-ssrs-report-rdl-xml-from-the-reportserver-database/

  • June 19, 2016 at 12:48 am

    #1885763

    Thanks for the link pietlinden.

    I was having a hard time find stuff that was related to actually producing the report

    Cheer,

    Steve

  • June 19, 2016 at 7:36 am

    #1885767

    Once you use the code in the link, you could use XQuery to extract the information from the report's XML that you need... just parse it and then insert that result into a table.

Viewing 4 posts - 1 through 3 (of 3 total)

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