How to Export SSRS Report Details

In the forums someone said they needed a query for a built-in report in order to export the report’s results. I advised them that there was no need for a query because all of the built-in ConfigMgr reports can be exported natively!

In fact, you can export all SQL Server Reporting Services (SSRS) reports to several different file formats:
· XML file with report data
· CSV (comma delimited)
· MHTML (web archive)
· Excel
· TIFF file
· Word

Note: This list will vary based on what version of SQL is installed.

How do you export your report results?

Simply click on the floppy disk icon How to Export SSRS Report Details-Floppy Disk Icon in the toolbar. This will expose the various file types that you can use to export the report results.

Then select the file type that you want.
How to Export SSRS Report Details-Select File Type

The file will be saved to your download folder on your computer. This is a great way to save copies of your reports. The exported results can be used in many ways, including adding a TIFF within a document or editing the results in an Excel spreadsheet.
How to Export SSRS Report Details-Save Report 

See how Right Click Tools are changing the way systems are managed.

Immediately boost productivity with our limited, free to use, Community Edition.

Get started with Right Click Tools today:


  • This field is for validation purposes and should be left unchanged.


  • This field is for validation purposes and should be left unchanged.

By submitting this form, you understand that Recast Software may process your data as described in the Recast Software Privacy Policy.