How to get a source code for SSMS reports?

• SQL Guy 1

  SSCoach

  Points: 15981

  More actions

  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

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  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