Excel Format In destination.

Question

Hello ALL, 
 I created a report destination which is EXCEL and PDF but i exported a report using EXCEL format i created it didn't properly align on the EXCEL SHEET. 
 
 Please help me its Urgent. 
 
 Thanks

shvidky · Accepted Answer

Glad to hear that removing grouping in Crystal solved your issue. I would copy what you have and create two more excel options. We found that Excel 97-2000 (extended) worked better and it is our default right now. However, my Excel1 destination uses Excel 97-2000 and Excel2 (workbook extended). Formatting can be pretty tricky, but workbook extended is used when you have too many lines and the first two formats throw errors.

Girts Mazais · Answer

From my experience - you shall carefully align all fields in Crystal report so, that there does not stay any empty space between them. 
 If there will be empty spaces - those will be transformed as an additional column in Excel. Same about rows - for example in Crystal Report if fields will be indifferent high, it can lead to empty rows in Excel.

Sage X3

Excel Format In destination.

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING