Export to Excel Without Page Breaks

In SSRS, by default, the Export to Excel option will render a report with Page Breaks into multiple tabs.  This is fine if you want to view the data this way, but if you would prefer to have all the data on one tab then you will need to do the following in the design view of the SSRS Report: 

1. Click the group object under Row Groups.

2. In the Properties, Click on the Group arrow to expand if the section is not already expanded.

3. Click on the Group arrow on the second line under Group to expand. 

4. Click the arrow to expand PageBreak.

5. Select End for BreakLocation

6. Select Expression for Disabled and type the following in the expression: =IIf(Globals!RenderFormat.Name="EXCELOPENXML", True, False)

7. Save and check the report to ensure the fix worked.