Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

unable to export to excel 8.0 extended format

Status
Not open for further replies.

cancer2006

Programmer
Aug 25, 2006
45
US
I am using CRW8.5 with Access 97 database. Reprot is giving me desirted output in the CRW8.5. However, when I export to Excel using the Excel8.0 extended format the columns are not showing in the correct order.

I also tried exporting to PDF and it is working there.
But I need to use excel extended format. My columns range is from A to Z, AA to AH.

Brief Description about the report:
There is a subreport in the Report Header A and some formula fields in Report Header B. Page Header contains the column headings.

Thank you very much for your help.
 
In 2003, there was a change in Crystal 8.5 exporting that improved it a great deal. If your export-choice says things like Excel Extended rather than MS Excel 97, then an update should fix it. I assume 'BO' still have them for Crystal 8.5 customers.


[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
I have installed SP3 for CRW8.5, do I need some thing for Excel 2003. Do you adding sub report can cause the problem.
 
You need the dll files. Talk to whoever you got the software from.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top