I recently had this requirement to export a report to excel. The user wanted everything in one sheet. It was a long report so the data was spread over several sheet upon export.
The solution is to set the Rows per Page Property of the list or crosstab to maximum. Excel 2010 can accommodate 65536 rows. So if your report has less rows than that, you are in luck.
So to conclude, Rows per Page property of list or crosstab also affects the output export to excel, not just for HTML outputs, as I previously thought.
No comments:
Post a Comment