Export Multiple Datasets to Multiple Excel sheets in ssrs

reporting-services ssrs-2008-r2
Arun Kumar picture Arun Kumar · Jun 18, 2014 · Viewed 17.5k times · Source

I have Three different dataset in one Report, Each Dataset result is binded to a different Table component

When I export as Excel ,I am getting all this in One Excel sheet

I need this in separate excel, How can I do this in SSRS

Thanks, Arun

Answer

Naveen Kumar picture Naveen Kumar · Jun 18, 2014

In this Case you have to set PageBreak BreakLocation to END and give unique PageName

Follow these steps 1. Select Table 1 press F4 to open Properties window and find PageBreak Option Set BreakLocation to END, Disabled False, ResetPageNumber False and finally PageName "Sheet 1"

Follow same steps for other two tables but make sure you have unique PageName like "Sheet 2" and "Sheet 3" in this case...

All the Best!

Related questions

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Format to display as percent

I've gone through quite a few examples on here and I apologize if I'm asking a repeat question, as far as I can tell, I am not. I have an SSRS report made that shows gross sales for certain aspects …

Read More
SQL Server Reporting Services 2008 R2 always show for login prompt

Whenever I try to access SSRS 2008 R2 through a URL (i.e. after being published on the net), it always shows a login prompt when accessing the report. The problem does not appear in the development environment. How do I …

Read More