Not All Data Will Export To Excel...WHY?

[jnt2000]

I have 15 reports that I need to refresh on a daily basis. Most of the fields in the report contain short information such as names, address, phone numbers etc. However, I do have one long field that contains long descriptive information, maybe 1500 to 2000 characters. (approx) These reports need to be distributed in Excel, so my client's can manipulate the data on there end. The problem I am running into, is when I export the report, this long field will only copy over about the first 250 characters, and the rest of the data is gone for that cell. What am I not seeing?

Thank You for your help, and your suggestions are very much appreciated.

Jay

 

[shweta]

Hi jnt2000,

What version of CR are you using? Also try exporting to excel 7 or excel 8 (Standard not extended format).

You will still see 255 chars in a cell, but the remaining can be seen in cells below that one. Basically crystal splits the contents of the field into 255 char segments and exports each segment into a cell. So what you may have to do is leave some blank lines between consecutive records so that the data from one doesn't mix with the next record.

Also the 255 characters will go way beyond the page width in excel!

So in short there is no easy way of doing this, and still making the report look good. We tried this a lot and then we came with a solution of exporting the report to HTML and then opening the HTML file in excel and saving it as an excel file. This doesn't look bad and all your long text wraps into one cell.

Good luck!
-Shweta

 

[leostr]

I have this exact same problem, using Excel 97. I have found that exporting to CSV fixes the problem!

 

[LoaferMan]

Excel can only hold 254 characters in a cell. On one project we had to physically write data in our application into multiple 254 character fields in the database and have our application merge them back together on the screen. This made it possible for Crystal to query the multiple fields in the database. You might be able to do this in your database, then the export would only be pulling 254 character fields and writing them correctly to Excel using the Excel export in Crystal.

LoaferMan

 

[rhinok]

Crystal reports only exports up to 255 characters to an Excel cell, regardless of how many characters the cell is actually able to hold.

Please refer to the following Cystal Decisions Support Document:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_exportexcel.pdf

You might try exporting your report to a different format first. Alternatively, you could break up your memo field into multiple fields. I've had to do this with my own reports.

Good luck!