I have designed a Crystal Report which keeps shows how many types of call my sales force has made. It works great when viewed in the Crystal Reports environment. But when I try to view it through a custom web app written in .Net, I get a Ole Db multistep error. When the data is saved along with the report, the report loads correctly. But as soon I save it without data, it gives me the error. This is my code:
Dim CR_Report As New ReportDocument CR_Report.Load(Session("RPTPATH") & "ProgramsNew.rpt")
With crConnectionInfo .ServerName = "p:\act\pharm.pad"
.DatabaseName = "" .UserID = "Ken Indictor" .Password = "" End With
CrTables = CR_Report.Database.Tables For Each CrTable In CrTables crtableLogoninfo = CrTable.LogOnInfo crtableLogoninfo.ConnectionInfo = crConnectionInfo CrTable.ApplyLogOnInfo(crtableLogoninfo) 'Set the location of each individual table CrTable.Location = crConnectionInfo.DatabaseName & CrTable.Location.Substring(CrTable.Location.LastIndexOf(".") + 1) Next