Crystal Report when saved as Excel file.

building reports crystal reports
1

Hi BOBJ’S,

Need a small suggestion.

I have recently updated a crystal report with changes as requested by my client. I haven’t touched columns as far as I remember. They are as they were before. I have only made some changes to header and so on. However client replied back saying

Information on the reports are set up in different columns.
Ex:
For the old file, VALUE was in Excel column K
For the new one, it is in merged in Excel column’s K L and M .

Any suggestion why would this happen? Help would be much appreciated.

Keerth007 :uk: (BOB member since 2009-03-21)

2

Did you change any of the column labels? That could cause this. Crystal’s Excel export is VERY picky about formatting. You could take a look at this article on Facebook: http://on.fb.me/RddYL9

I wrote this a while back and it explains how to configure a report for a clean export to Excel.

-Dell

hilfy :us: (BOB member since 2007-04-16)

3

I did add a column but not on the details tab where all the columns are.I have added in the page header.

I don’t have access to Facebook but I will have a look later.

Thanks for responding.

Keerth

Keerth007 :uk: (BOB member since 2009-03-21)

4

Adding it in a header without making sure that it’s lined up exactly with the fields in the detail will cause merged columns.

-Dell

hilfy :us: (BOB member since 2007-04-16)