I can't get my Crystal 8.0 report to return any data when I run it from VB 6.0 - it pulls up the report but no records are returned. When I run the same report from Crystal, it works.
I'm wondering if it has to do with logging on to SQL Server 7.0. When I run the report from Crystal, it ALWAYS prompts me for a password - it doesn't look like you can save it.
I have declared a Crystal Reports object in VB, and I am passing the connection string, including the password (see below).
CR.ReportFileName = App.Path & "\" & strReportName
CR.ParameterFields(0)= "ReportType;strReportType;True"
CR.LogonInfo(0) = "UID=ipdnetuser;PWD=ipdnetuser;Driver=
{SQL Server}; Server=IPDSQL1; database=policytracker"
CR.PrintReport
How can I get this report to run from my VB app, pull back the desired records, and NOT prompt the user for a password?
I'm wondering if it has to do with logging on to SQL Server 7.0. When I run the report from Crystal, it ALWAYS prompts me for a password - it doesn't look like you can save it.
I have declared a Crystal Reports object in VB, and I am passing the connection string, including the password (see below).
CR.ReportFileName = App.Path & "\" & strReportName
CR.ParameterFields(0)= "ReportType;strReportType;True"
CR.LogonInfo(0) = "UID=ipdnetuser;PWD=ipdnetuser;Driver=
{SQL Server}; Server=IPDSQL1; database=policytracker"
CR.PrintReport
How can I get this report to run from my VB app, pull back the desired records, and NOT prompt the user for a password?