Download in Excel issue

building reports crystal reports
1

Hi,
Currently when I download Crystal report in Excel, Excel report columns are not the same as Crystal Report. I meant Crystal Report one column is showing multiple cells (A, B, C) in Excel. Example: when I download Sales Revenue report in Excel, “Profit” field is downloaded in Cell A, CellB and Cell C in Excel. Is there any way Crystal report each field download in each celln Excel (no multiple excel cells are merze)

Philip (BOB member since 2006-03-02)

2

There are few things to keep in mind when designing a report to export nicely in excel like keeping the same height and width for each header labels and detail columns, selecting “Fit Section” so there are no gaps in between sections, etc.

Here is a detailed document that will assist in creating/modifying a Crystal Report from 10 and later versions that exports successfully to Microsoft Excel.

AnthonyJ :philippines: (BOB member since 2006-06-30)