Post reply

How to get a source code for SSMS reports?

  • February 27, 2019 at 8:21 am

    #379533

    In SSMS v17.4 they have a set of reports in <Database>/Reports/Standard reports. How to extract a source code for them? I tried to do something from DMV views but my results don't look identical to their.

    Thanks

  • February 27, 2019 at 11:00 am

    #2023108

    SQL Guy 1 - Wednesday, February 27, 2019 8:21 AM

    In SSMS v17.4 they have a set of reports in <Database>/Reports/Standard reports. How to extract a source code for them? I tried to do something from DMV views but my results don't look identical to their.

    Thanks

    Those reports use the Report Viewer control and rdlc files. They are stored in the file Microsoft.SqlServer.Management.Reports.dll
    You would need to use a .Net decompiler, view the resources and save the rdlc to some other directory and then you'd have your own copy of the rdlc file.

    Sue

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

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