asked on

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

ASKER CERTIFIED SOLUTION

crgary_tx

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

datriceao

ASKER

When I choose (Data Only) I don't see an option for Custom?

Datrice

Mike McCracken

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

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

crgary_tx

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

datriceao

ASKER

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

Datrice

crgary_tx

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

datriceao

ASKER

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

Mike McCracken

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

mlmcc

datriceao

ASKER

Yes, I get a speadsheet created with the errors.

Mike McCracken

What errors? If you mean the extra spaces and lines then you need to format the report according to the link above.

mlmcc