Search code examples
reporting-servicesssrs-2008-r2

Export Multiple Datasets to Multiple Excel sheets in ssrs

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

Solution

  • 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
    2. Find PageBreak Option Set BreakLocation to END,
    3. Disabled = False
    4. ResetPageNumber False
    5. nd 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!