Microsoft SQL Server 2012 RC0 Released

Hi Guys, So finally after a long wait, while you patiently used SQL Server Code Name "Denali", Microsoft has finally released the Release Candidate for SQL Server 2012. Its officially available to be downloaded from Microsoft Website at

http://www.microsoft.com/download/en/details.aspx?id=28145

Take a sneak peak and start playing around with all the new features of it. 

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