I can pull and save data from my VB program without a problem. When I try to use Crystal Reports I can display a report if it has no parameters, and if the "Save Data with Report" option is checked. I need to be able to pass parameters, when I try this, it complains and gives me an error "Cannot open SQL server".
I'm using the OCX method (added a component into my VB form). And I pass the connection information in my code:
How can I get rid of that error so I can pass parameters?
Any help is appreciated. Thanks!
I'm using the OCX method (added a component into my VB form). And I pass the connection information in my code:
Code:
Me.rptReport.Connect = "DSN=" & servername & ";UID=" & username & ";PWD=" & passwordStr & ";DSQ=" & dbname
Any help is appreciated. Thanks!