Crystal report not exporting format correctly to Excel.

I am trying to export a cross-tab report from Crystal Reports 9 to Excel 2003 and when I do so the report exports with extra spacing and the page numbering is off. Help!

Thanks,
Datrice

datriceaoAsked:
Who is Participating?
 
crgary_txConnect With a Mentor Commented:
Choose export option: MS Excel (Data Only) and enable the radio button Custom

Gary
0
 
datriceaoAuthor Commented:
When I choose (Data Only) I don't see an option for Custom?

Datrice
0
 
mlmccCommented:
Here is an article from Crystal explaining how to setup the report to export to Excel

http://support.businessobjects.com/communityCS/TechnicalPapers/cr10_export_excel.pdf.asp

mlmcc
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
crgary_txCommented:
Its not just custom it is:
Custom:Data is exported according to the selected options

you need to choose your export option as MS Excel 97-2000 (Data only) Export Options

Gary
0
 
datriceaoAuthor Commented:
I am working in CR9 and don't have that option when selecting export MS Excel 97-2000 (Data only).

Datrice
0
 
crgary_txCommented:
There is an option for that. Refer to the article mlmcc sent:

http://support.businessobjects.com/communityCS/TechnicalPapers/scr_exportexcel.pdf.asp

I am using Crystal XI here. In XI it is:

File-->Export-->Report Export Option
and choose
MS Excel 97-2000 (Data only) XLS from the drop down.

It should be more or less same in version 9 too.

Gary
0
 
datriceaoAuthor Commented:
When I try that I get an Export dialog box that has a Format and Destination drop-down. I choose MS Excel 97-2000 (Data only) and Disk File for destination, ok. I then get a Excel Format Options box that gives me an option to change the column width, export page header and page footer, simplify page headings and use worksheet functions to represent subtotal fields in report.

Datrice

0
 
mlmccCommented:
As expected.  WHen you set those options as you desire and click OK do you get a spreadsheet created?

mlmcc
0
 
datriceaoAuthor Commented:
Yes, I get a speadsheet created with the errors.
0
 
mlmccCommented:
What errors?  If you mean the extra spaces and lines then you need to format the report according to the link above.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.