cfriedberg
MIS
I have a complex report with several sub reports developed outside of VB. It accesses a Stored Procedure in SQL Server 2000. Now I want it to be viewed with the Crystal Report Viewer.
This is the code:
Report.Database.LogOnServer "P2ssql.dll", "mysrv", "MyDataBAse", "MyUserID", "MyPassWord"
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
The dialog box prompting for the date parameter comes up and I can enter the date. After that I get a Crystal Reports: Database Error, saying "General SQL Server error: Check messages from the SQL Server." There seem to be no messages looged into the SQL Server Logs.
This is the code:
Report.Database.LogOnServer "P2ssql.dll", "mysrv", "MyDataBAse", "MyUserID", "MyPassWord"
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
The dialog box prompting for the date parameter comes up and I can enter the date. After that I get a Crystal Reports: Database Error, saying "General SQL Server error: Check messages from the SQL Server." There seem to be no messages looged into the SQL Server Logs.