I want to export a Crystal Report to PDF file, but without opening Crystal Report form in Visual Basic.
Printable View
I want to export a Crystal Report to PDF file, but without opening Crystal Report form in Visual Basic.
Moved to Reporting
Which version of Crystal? Check the following thread
http://www.vbforums.com/showthread.php?t=357094
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