ExportOptions 1

[julian92128]

Can some one help me, I'm trying to export a report to rpt from a visual basic program, but it gives me the message box asking for options, I want this to be set in code.


Thanks in advance


Julian

 

[MattKirby]

Just like you can do Report.Export, you can do Report.ExportOptions.whatever, and set many export options.

 

[balves]

Dim repReport as (your report designer name here)
Dim crystalExportOptions As ExportOptions

Set crystalExportOptions = repReport.ExportOptions

crysExportOptions.DestinationType = crEDTDiskFile
crysExportOptions.DiskFileName = "your output file name"

' pick a format like ...

crysExportOptions.FormatType = crEFTExcel80
' or
crysExportOptions.FormatType = crEFTRichText

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