Export SSRS Report

Reports generated by the SSRS can export in a variety of formats. In this article, we will show you the step by step approach to export SSRS report generated by the SQL Server Reporting Services

For this example, We are going to use the below-shown DataSet. Please refer to Shared Data Source and Dataset articles to understand the steps involved in creating Shared Data sources and Dataset that we used for this SSRS report.

Format Table Report in SSRS 1

And the Custom SQL query that we used in the above Dataset is:

-- Export SSRS Reports
SELECT Prodcat.EnglishProductCategoryName,
       prodSubcat.EnglishProductSubcategoryName,  
       prod.EnglishProductName, 
       prod.Color, 
       fact.[TotalProductCost],
       fact.SalesAmount, 
       fact.TaxAmt,
       fact.[OrderDate],
       fact.[ShipDate] 
FROM dbo.DimProduct as prod 
  INNER JOIN 
dbo.DimProductSubcategory AS prodSubcat ON 
       prod.ProductSubcategoryKey = prodSubcat.ProductSubcategoryKey 
  INNER JOIN  
dbo.DimProductCategory AS Prodcat ON 
       prodSubcat.ProductCategoryKey = Prodcat.ProductCategoryKey 
  INNER JOIN  
dbo.FactInternetSales AS fact ON 
       fact.ProductKey = prod.ProductKey
WHERE SalesAmount >= 3500

Export SSRS Report

To explain the steps involved in exporting SSRS Reports, We are going to use the below-shown report. Please refer SSRS Table ReportFormat-Table Report in SSRS article to understand the steps involved in creating and formatting Table Report, and refer Grouping in SSRS Table Report article for Grouping techniques.

Export SSRS Report 3

Let me show you the Report Preview.

Export SSRS Report 4

Within the Preview tab, if you click on the Save button, it opens the context menu with available export Options. And they are:

  • XML file with report Data: Report will save in XML format. File extension will be .xml
  • CSV (Comma Delimited): SSSR Report saved in CSV (Comma Separated Value) format. File extension will be .csv
  • TIFF file: Report saved in Tagged Image File Format. The file extension will be .tiff
  • PDF: Report will save in PDF format. File extension will be .pdf
  • MHTML (Web Archive): Report will save in MIME HTML format. You can use any web browser to see this file. File extension will be .mhtml
  • Excel: SSRS Report will save in the Microsoft Excel Spreadsheet format. The file extension will be .xlsx
  • Word: Report Saved in Microsoft Word Document format. File extension will be .docx
Export SSRS Report 5

Export SSRS Report to CSV File

In this example, we will export the SSRS report to CSV file. To do this, Please select the CSV option from the context menu

Export SSRS Report 6

It will open the SaveAs dialogue box to save the CSV file. Here you can select the Drive, or Folder (Location) to save this CSV file.

From the below screenshot, you can see that we are selecting the REPORT folder in our E Drive.

Export SSRS Report 7

Let me open the CSV file. As you can see, it is displaying all the records that we generated in the SSRS report.

Export SSRS Report 8

Export SSRS Report to TIFF File

In this example, we exports report to the Tagged Image File Format. To do this, Please select the TIFF file option from the context menu

Export SSRS Report 9

This will open the SaveAs dialogue box to save the TIFF file. From the below screenshot, you can see that we are saving this file to REPORT folder in our E Drive.

Export SSRS Report 10

Let me open the TIFF file. As you can see, it is displaying all the records that we generated in SSRS report along with the Format (Grouping).

Export SSRS Report 11

Let us see some other page in TIFF file

Export SSRS Report 12

Export SSRS Report to PDF

In this example, we will export the SSRS report to PDF format. To do this, Please select the PDF option from the context menu as we shown below

Export SSRS Report 13

From the below image, see we are saving this PDF file to the REPORT folder in our E Drive.

Export SSRS Report 14

Let me open the PDF file. It displays all the records that we generated in the SSRS report along with the Format (Grouping).

Export SSRS Report 15

Export SSRS Report to Excel File

In this example, we will export SSRS report to Microsoft Excel Spreadsheet Format. To do this, Please select the Excel option

Export SSRS Report 16

Here, we are saving this Excel file to the REPORT folder in our E Drive.

Export SSRS Report 17

Let me open the Excel spreadsheet. You can see, it shows all the records along with the Format (Grouping).

Export SSRS Report 18

Export SSRS Report to Word File

In this example, we will export SSRS report to Microsoft Word Document. To do this, Please select the Word option from the menu

Export SSRS Report 19

Here, we are saving this word document in our E Drive.

Export SSRS Report 20

Let’s open the doc file. 

Export SSRS Report 21

Export SSRS Report to XML File

In this example, we export SSRS report to XML Format. To do this, Please select the XML file with report data option

Export SSRS Report 22

Let me save this XML file to the REPORT folder.

Export SSRS Report 23

Let us open the XML file in the Microsoft Edge browser. As you see, it shows all the records that we generated in XML format.

Export SSRS Report 24

Export SSRS Report to MHTML

In this example, we export report to MIME HTML Format. To do this, Please select the MHTML (Web Archive) option

Export SSRS Report 25

We are saving this mhtml file in our E Drive.

Export SSRS Report 26

Let’s open the MHTML file in the browser. It is displaying all the records we generated in the SSRS report along with the Grouping.

Export SSRS Report 27

Let me open the Report folder. Here, you can see all the file formats that we saved in the example.

Export SSRS Report 28