Ok, so I've tried making the crystal report use a dataset(XSD) for the report data and am still recieving the login failed message. This is even after I created a new report. The code I'm using is below.

Any suggestions?

 Dim crTableLogOnInfo As New TableLogOnInfo()
 Dim crConnectionInfo As New ConnectionInfo()
 Dim crDatabase As Database
 Dim crTables As Tables
 Dim crtable As Table
 Dim oRpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
 Try
    RefreshControls(False)
   daGetData.SelectCommand.CommandText = dsReports.Tables("reports").Rows(cboReports.SelectedIndex).Item("StoredProc")
   daGetData.Fill(JobSearch, "contacts")
   hplPrint.Visible = False
   oRpt.Load(Server.MapPath(Me.dsReports.Tables("reports").Rows(Me.cboReports.SelectedIndex).Item("CrystalReportName")))
    Me.crReport.ReportSource = oRpt
    oRpt.Database.Tables("contacts").SetDataSource(JobSearch.Tables("contacts"))
    crReport.Visible = True
Catch exp As Exception
    setMessage(exp.Message)
End Try

>Jim,
>
>I've never had to set a connection when I use datasets - I open/load the report, go through my setdatasource loop, and then print/show it.
>
>I've used this approach with CR.NET and am using the same approach with the .NET assemblies that come with CR10.
>
>Kevin