Crystal report export to Excel with wrong page size

Question

I have designed the report in A4 size, When I export to PDF, the size fit well. However, when I export the report to Excel 2000/2003, the report cannot fit in a page. Could anyone tell me how to fix it ? Thanks

Answer 1

Excel uses own size of paper (not like printer - because all the printers have borders, "print area", etc.) And no all the export filters can correctly create file. For example (I use FastReport, which has set of different export filters to Excel - direct biff8, XML, OLE and also third party exports) and different expolt filters give different results. I like Biff8 and xlsx (fastest and with pictures).

For your case - create smaller size of report template.