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
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
No comments:
Post a Comment