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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report 8.5 export to Excel problem

Status
Not open for further replies.

Crazyec

Programmer
Aug 28, 2001
80
HK
Hi All, I'm facing problem about exporting the crystal report to excel. My application develop on VB6 and calling the crystal report thru crystal report viewer.

My user export the crystal report to Excel 7.0 as normal, but the rows show different. Before, the excel will show a blank line between column header and the details. But now, the blank line gone. User has no idea what they changed, but not all user have this changes (they are using NT workstation 4.0)

The blank line, should be the 1.5 point thick line. Between the line and the detail, it is a group section which set "Keep Together" in the design. Is there any idea about that? What will affect the line and the blank row in excel? If I want to make that blank line, what should I do?
(Actually, the excel is used to be a import source of next program).

Thank you.

 
You have an older version of the Crystal 8.5 dlls. They improved it a few years back and it should say MS Excel 97 etc.

As for how you get hold of the updated dlls from a produce that they no longer support, someone else will have to tell you.

[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