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...
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...
