Wednesday, June 29, 2011

How to get a SSRS report exported in multiple excel sheets

Hi,

In this post, we will address an issue relating to exporting a SSRS report.

One of my client had a report which showed data from 2 different Datasets in one Report. Everything looked fine to him, by the time he didn't exported it, since the data from 2 different datasets was imported in the same excel sheet.

To resolve the issue, all we really need to do is set a simple setting. You must be using 2 Tablix controls in your report to show the data. Just go to the properties of the first Tablix and set the value of Page Break -> Break Location to End. The default value should be null.



Figure 1 - Default Setting                                    Figure 2 - Changed Setting


Now when you will export the Report data. It will be exported to 2 different sheets in the Workbook. You can do the same for multiple Tablix in the same reports :-). Cool Huh...

No comments:

Post a Comment