Is, configure the RepeatWith property of the Header text box. There are several options for that and the very basic option The last option is to repeat the heading on every page. Similarly, the page name of the next tablix is named Clothing as shown in the below screenshot. For example, we would like to name the sheets as Bikes and Clothing instead of Sheet1, Sheet2.īy selecting the relevant tablix and changing the PageName to Bikes will change the sheet name to Bikes as shown in However, we would like the name them with a To add a page break, go to the properties of the first table or the tablix as shown below.īy selecting the Add a page break after, you are adding a page break after this table.Īs you know, by default, sheets will be named as Sheet1, Sheet2 etc. Three different configurations have to be done for this and let us do this configuration one by to implementĮxporting SSRS Reports to Multiple sheets of Excel. There are three tasks in order to create multiple sheets.Ĭreating a Page Break after the Bikes table Further, Sheet names should be Bikes and Clothing. When this is exported to Microsoft excel, typically this will be exported to one sheet whereas the requirement is,Įxporting SSRS Reports to multiple sheets of Excel. Please note that in order to demonstrate, only the top five records are retrieved and the following screen shows the Similarly, another data set is created for the clothing and two tables are included as follows. This is configured as shown in the following screenshot: WHERE (DimProductCategory.EnglishProductCategoryName = ‘Bikes’) SELECT TOP (5) DimProductSubcategory.EnglishProductSubcategoryName, DimProductCategory.EnglishProductCategoryName, DimProduct.EnglishProductName, FactInternetSales.SalesAmount, FactInternetSales.TaxAmt,įactInternetSales.Freight, DimDate.FullDateAlternateKey, FactInternetSales.SalesOrderNumberĭimProduct ON FactInternetSales.ProductKey = DimProduct.ProductKey INNER JOINĭimProductSubcategory ON DimProduct.ProductSubcategoryKey = DimProductSubcategory.ProductSubcategoryKey INNER JOINĭimProductCategory ON DimProductSubcategory.ProductCategoryKey = DimProductCategory.ProductCategoryKey INNER JOINĭimDate ON FactInternetSales.ShipDateKey = DimDate.DateKey The query for one data set by joining FactInternetSales, DimProduct, DimProductCategory and DimProductSubcategory. Let us create two data sets where one has the bikes data and the other data set has data of clothing. Pointing out the AdventureWorksDW sample database. Then let us add a report to the newly created SSRS project. Let us launch the Visual Studio or SQL Server Data tool (SSDT) and create a Reporting Words, sheets are dynamic as they depend on the data setįirst of all, let us create a sample report in order to demonstrate the feature of exporting SSRS Reports to Set may require exporting SSRS Reports to multiple sheets of Excel depending on these categories. ForĮxample, sales tablix will have product categories of Bikes, Components, Clothing, and Accessories.
Same Tablix in Different sheets: In this requirement, the same tablix will have different groups of data. There are a couple of scenarios of requirements for exporting SSRS Reports to multiple sheets of excel.ĭifferent Tablix in Different sheets: In this requirement, there will be multiple tables/tablixes that you need The challenge that many users experience isĮxporting SSRS reports to multiple sheets of excel. Excel savvy users prefer to group the data into sheets. For example, in Microsoft excel there are sheets that are used to Tiff file, MHTML (Web Archive), CSV (comma delimited) and XML file with report data are the popular formats that canīe exported from SSRS as shown in the below screenshot.Īs you know, every format has its own features. Microsoft Word, Microsoft Excel, Microsoft PowerPoint, In SSRS, there are multiple formatsĪvailable to export reports depending on the user’s needs. SQL Server Reporting Services (SSRS) has multiple options of exporting data into a variety of formats and we will beĭiscussing the options of exporting SSRS Reports to multiple sheets of excel.