SSRS Subreport Exported to Separate Excel Tab

We have a report that consists of 2 enclosed subreports, created using SQL Server 2008 SSRS.  When the report is exported to Excel, we want the main report and the 2 subreports to appear on separate tabs in Excel.  Is this possible, and how can we do this?
KaporchAsked:
Who is Participating?
 
catherinelouiseCommented:
You can achieve this by inserting a rectangle (from the Toolbox) after each block (i.e. after your main report, and then each subreport).

Right click on the rectange, choose Properties and then check the Page Break tick box 'Insert after rectangle'

Each page break will export into excel as a new sheet.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.