Subreport alignment problem while exporting to excel format

101 Views

Post Author: gayatrys

CA Forum: Exporting

Hi,

We are using crystal report 11 and vs 2005. We need to export the crystal report in various file format. The crystal reprot contains subreports also. While export to PDF, WORD format, we are able to get the output correctly. That is the reports with subreports and contains many pages, alignment is also correct.

Our major requirement is to export the reports to excel file format.

We are not able to get the output properly. That is, we are supposed to get header , details and footer for mutiple page. But when we export the report to excel we get only one header and one footer and other details on the same sheet. The header contains the serial no for the details. We are able to get only first serial no , other serial no are not displayed.

The aligment is also not correct in the excel. The same reprot when exported in PDF it is working fine.

Please help me to solve this issue.

Thanks in advance.

Gayatry. S