ssnowflake
Technical User
I am trying to run a crystal report from a VB app. The app isn't going to do anything but run that crystal report to print to file (excel format) upon load and then unload. However, when I run it, I get an error stating, "Unable to open SQL Server." The report needs connects to an Oracle DB server and I am trying to pass the username/password and database name in the properties of the CrystalReport ActiveX Control. Any help would be grandly appreciated. Here's my code of what is not working...
With frmCrystal.CrystalReport1
.ReportFileName = App.Path & "\balance.rpt"
.PrinterCopies = 1
.WindowControls = True
.Destination = crptToFile
.PrintFileType = crptExcel50Tab
.Action = 1
End With
With frmCrystal.CrystalReport1
.ReportFileName = App.Path & "\balance.rpt"
.PrinterCopies = 1
.WindowControls = True
.Destination = crptToFile
.PrintFileType = crptExcel50Tab
.Action = 1
End With