SQL Authentication in Crystal Report



I have a Crystal Report created by a coworker in Crystal Reports XI. The
report uses an ODBC DSN to connect to the SQL Server database.

I've figured out how to set the various parameters for the report, how to
point the Report Viewer to the .RPT file, etc.

The last step (?) for me is to provide a SQL username and password since the
report prompts for one when it runs.

I've reviewed the documentation online but can't seem to find an answer to
what feels like a pretty simple question.

Here's a bit of the code I'm using so far:
Dim frm As New frmReport
Dim docReport As New ReportDocument
docReport.Load ("{fullpath was long}Price_Comparison.rpt")
docReport.SetParameterValue("Company", "SR")
docReport.SetParameterValue("Branch", "SR")
docReport.SetParameterValue("Show_All", True)

frm.CrystalReportViewer1.ReportSource = docReport


Help? I posted this quite a while ago and haven't received a response. I
expect this is a fairly simple answer that has for some reason eluded me.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question