Report Viewer: Export to Excel in One Sheet

When you group your report based on some column, and then try to export to excel, it inserts a page break after certain records.

If you want to export complete data in one sheet of excel workbook. Do the followings

1. Right Click on Rdlc file

2. Select Open With

3. Select “XML (Text) Editor”

4. Add this tagĀ <InteractiveHeight>0in</InteractiveHeight> inside <Page> tag

5. Save the file

6. Open the report

7. Remove all other page breaks from the reports

8. Remove the group page break as show in the attached image

9. Remove the report viewer height

Run the report, it will show results in one window as well as it will export the data in a single sheet of excel workbook