Friday, February 24, 2012

export to excel

Hi ,
I have a simple report which i want to export to excel format. the are no groups in the report. I need each page of the report to appear as a seperate page in excel. currently when i export the report i get a single continuous page. is there any way in which i can do this ?

If you have a page break set on group or detail then these will output of separate sheets.

However, the idea of "paging" in Excel is very different than your HTML/PDF output, etc. It has no concept of what a new page is unless you tell it specifically where to page break. That might be on a group..or based on an expression that breaks say, every 100 rows of detail.

No comments:

Post a Comment