Exporting Issue

building reports crystal reports
1

Hi,

I have a crystal report having 4 fields, but when I export it to excel first field is coming in A, second field is coming in C third field is coming in D and fourth field is coming in F, but B and E are blanks which this is happening?

Is it a kind of bug in Crystal report to excel exporting??

Thanks,

Tims_Bo :india: (BOB member since 2008-07-26)

2

Crystal is VERY picky about formatting when exporting to Excel. In order for this to happen correctly you need to do the following:

  1. Align the left sides of an data and its corresponding column header.
  2. Make the column header and the data in it the exact same width.
  3. At the top of the page, set a “guide” at the end of the column.
  4. Set the left of the next column and its header at the guide that you just placed. This means that the column starts exactly where the previous column ends.
  5. Do NOT use and lines between the columns and/or rows - if you need lines, set the borders on the objects in the report. Drawn lines will cause extra columns and rows.
  6. If you have any page or report headers or footers, the objects in them MUST line up with the data columns. If need be, you can span multiple columns but the left and right sides of the object must each line up to a column edge in the data.

-Dell

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

3

This is the answer to your question.

I suspect definitely there will be blank fields after 1st field and 3rd field in your report. In preview you will feel all fields are coming continuously, but when you export to excel, no matter what is the size of the filed, no matter you suppress it or not, it will always count a field as a cell in Excel.

Hope it helps.

anil.ganga1 :us: (BOB member since 2007-07-04)