Crystal 8 Report exports incorrectly to Excel 1

[marydn]

I am trying to export a Crystal 8 report into Excel 97. The Report spans 61 inches. When I export it into Excell the fields are not in the same order as they were in the Crystal report. My question is simple (?) - how can I get my Excel spreadsheet to look like my Crystal Report?

 

[kenhamady]

What do you mean by the report spans 61 inches? Are you using a custom paper size? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[marydn]

Yes I am using a printer that will print out to this length. In Crystal the ruler goes out to 61 inches in order to capture all my fields.

 

[balves]

There's a document on the Crystal web site about exporting to Excel. Some of the big things are don't overlap columns, don't leave space between fields, snap objects to the grids, all objects in a row have the same height, etc.

http://support.crystaldecisions.net/communityCS/TechnicalPapers/SCR_exportExcel.pdf.asp

Brian J. Alves
Terrier Consulting, Inc.
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer

 

[AnonymousJane]

I found that sometimes when I exported my reports to Excel 8.0 (Extended) that I would get an extra row between each line of data. I'm not sure if this will answer your question but now when exporting to any version of Excel, I choose "Tabular Format". This exports all columns EXACTLY as how they look in Crystal Reports. This is only in CR v8, in CR v6-v7, I accepted the default exporting format.

 

[chiarak]

Hi

I have a crystal report which when I export to excel 8.0(Extended) turns out exactly as I require. However I need to view this report via my web server and the export option does not include excel extended - is there a way around this?? The regular export on the web server is inserting blank lines even when I follow the guidelines above.

Thanks

Chiara

 

[kenhamady]

Sounds like the web server may have different export DLL files than you do on your PC. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[chiarak]

Hi

I don't actually have access to the web server to check the dlls but which dll would need to be there for exporting to excel with entended options??

Thanks
Chiara

 

[kenhamady]

Check the version of u2fxls.dll.
You can export to XLS but not to extended?
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com