Problem Exporting Vertical Array Data to Excel (Crystal XI)

[charlesneve]

Hello,

I have an array of zip code ranges that I would like to have more control of for a web application. I was able to get the array to display vertically by using line feeds chr(10)+chr(13). However, when I export to Excel the data is not being displayed on individual rows. Instead each array is packed into one cell with soft returns.

Does anyone have a suggestion?

Sample data:

RepID:
BL02

ZipRanges:
01373, 01432, 01450-01451, 01460, 01467, 01469, 01503-01504, 01510, 01516, 01519, 01526, 01529, 01532, 01534, 01536, 01538, 01542, 01568-01569, 01581, 01588, 01590, 01605, 01719-01721, 1740, 01747-01748, 01752, 01754, 01756-01757, 01772, 01826

Report export:

RepID Zip1 Zip2
BL02 01373 01373
BL02 01432 01432
BL02 01450 01451
BL02 01460 01460
BL02 01467 01467
BL02 01469 01469
BL02 01503 01504
BL02 01510 01510
BL02 01516 01516
BL02 01519 01519
BL02 01526 01526
BL02 01529 01529
BL02 01532 01532
BL02 01534 01534
BL02 01536 01536
BL02 01538 01538
BL02 01542 01542
BL02 01568 01569
BL02 01581 01581
BL02 01588 01588
BL02 01590 01590
BL02 01605 01605
BL02 01719 01721
BL02 01747 01748
BL02 01752 01752
BL02 01754 01754
BL02 01756 01757
BL02 01772 01772
BL02 01826 01826

Thanks,
charlesneve

 

[crystalkiwibruce]

My Export UFL lets you define and build a grid inside the report, and you can then save the data to a CSV file. Worth a look at.

Trial version available for download from my web site.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[IdoMillet]

One of the 3rd-party Crystal Reports desktop schedulers listed at

http://kenhamady.com/bookmarks.html

allows you to feed the delimited values inside a Crystal formula to an Excel range. The range gets extended automatically based on the number of rows required. The advantage is that formatting is preserved and you can start with an excel file that has other elements (formulas, charts, ...) that use the range being filled.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com