Excel sheet expanding to new page when exporting from crystal report.

[vishwas13]

Hi All,

This is regarding the issue which I faced while exporting the crystal report to Excel format. In my application I am exporting the report to excel, pdf and word formats. I am using dotnet visual studio 2002 version.

The problem I am facing is that, what ever be the report exported to pdf is coming in one page while printing. But, the excel exported one is printing in two pages.

Is there any way we can set “auto adjust to page” while printing property to excel while exporting from crystal report?

Regards,
Vishwas