Cannot Export to Excel at Runtime using RDC 1

[meljon12]

I'm having problems exporting to excel at runtime using VB and the RDC Object model. I originally tried enabling the Export button toolbar on the CRViwer control, but a blank spreadsheet resulted at runtime.

I then tried to use a command button on the viwer with the following code behind it"

CRReport.Export PromptUser

I got the Crytal Report Export dialog boxes but after selecting the directory to export to I got the following error message

"Invalid Directory"

Any ideas anyone. Any code examples would help


Thanks

 

[balves]

Assuming that your RDC Crystal Report object is Report1:

Dim crystalExportOptions As ExportOptions

Set crystalExportOptions = Report1.ExportOptions

crystalExportOptions.DestinationType = crEDTDiskFile
crystalExportOptions.DiskFileName = " your output filename here"
crystalExportOptions.FormatType = crEFTExcel80
crystalExportOptions.Export False

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

 

[LloydV]

I just got the answer from Crystal: Exports via the RDC fail on Windows 2000, XP and (they claim, NT). Upgrade craxdrt.dll from 8.0.0.441 to 8.0.0.535 by applying patch ftp://ftp.crystaldecisions.com/outgoing/EHF/cr80dev.zip.