Use Export feature of Crystal Report

[sandippandya]

I want to export a Crystal Report to PDF file, but without opening Crystal Report form in Visual Basic.

[Hack]

Moved to Reporting

[brucevde]

Which version of Crystal? Check the following thread

http://www.vbforums.com/showthread.php?t=357094

[Pasvorto]

Here's an example:

Set Report = crxApplication.OpenReport("Z:\DAD\CorrectiveAction.rpt", 1)
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.ConnectionProperties("user id") = "sa"
crxDatabaseTable.ConnectionProperties("Password") = myPasswordTechniSQL
Next crxDatabaseTable
Report.RecordSelectionFormula = "{CORRECTIVEACTION.MDR} = '" & txtMDR.Text & "'"
Report.PaperOrientation = crDefaultPaperOrientation
Report.ExportOptions.FormatType = crEFTPortableDocFormat
Report.ExportOptions.DiskFileName = "C:\CorrectiveActionResponse-" & txtMDR.Text & ".pdf"
Report.ExportOptions.DestinationType = crEDTDiskFile
Report.Export False