• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5425
  • Last Modified:

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?
0
Kaporch
Asked:
Kaporch
1 Solution
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now