export crystal report with oracle db in VB
I create one standard exe file.
Then I add in a crystal report file with
oracle ODBC connection named as CrystalReport1
Together I add a crystal report viewer.
When I run the program, I got this error
"Server has not yet been opened"
This is the command to export the report out to pdf.
Private Sub Command1_Click()
Dim Report As New CrystalReport1
filedb = App.Path
With Report
.ExportOptions.ODBCDataSourceName = "DSNname"
.ExportOptions.ODBCDataSourceUserID = "Username"
.ExportOptions.ODBCDataSourcePassword = "Password"
.ExportOptions.FormatType = crEFTPortableDocFormat
.ExportOptions.DestinationType = crEDTDiskFile
.ExportOptions.DiskFileName = filedb & "VehicleExp.pdf"
.Export False
End With
End Sub
---------------------------------------
anybody please help me to solve this problem..
thanks
~G-mey~
|