Formatting issues when exporting to excel

[quisar]

Hi,

When we export crystal report 8.5 to excel we face following problems:
If Tabular option is selected, sections in the data get overwritten with report footer, or lables get shifted towards right. If subreport is used, alignment goes haywire.
If Non-tabular is selected, the format of the report is correct and the same as we view it. But there are multiple blank rows between each row in excel.

Note: The report when viewed in the previewer is perfect in case of both options mentioned above.

Pls help..

Regards,

Quisar.

 

[Madawc]

In 2003, there was a change in Crystal 8.5 exporting that improved it a great deal. If your export-choice says things like Excel Extended rather than MS Excel 97, then an update should fix it. 'BO' may still have them for Crystal 8.5 customers, though they've stopped supporting 8.5.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10