M
Milan Todorovic
Hello,
I need help. I have experience in ASP.NET programming, but this is my first
dealing with Crystal Reports. I'm trying to make the most basic report
purely for testing purposes: connect to the remote SQL DB and create a
report on one of the tables. Every time I do it, I get the Logon Failed
error (CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed)
The internet search shows that this is a common problem, especially for
those using the 'pull' method. In my case it occurs in both 'push' and
'pull' methods. The problem I guess lies in the lack of credentials to
connect to the data source (DB in this case). Most solutions mentions the
SetDatabaseLogon method, but that method does not belong to the
ReportDocument object even though the documentation shows that it should.
Even with all those solutions, I still haven't managed to solve my problem!
I have a feeling I'm missing something really obvious.
To explain what exactly I'm doing. In a project, I created the
CrystalReport1.rpt file, that connects to the SQL DB by specifying the
server, username and password (not using integrated security). In the
webform I created a CrystalReportViewer instance crv. In the code behind I
put the following code:
Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
rpt.Load("C:\\Inetpub\\wwwroot\\TestCrystal\\CrystalReport1.rpt")
crv.ReportSource = rpt
crv.DataBind()
What exactly do I need to do here to get this report to show? Any input is
greatly appreciated.
Thanks
Milan
I need help. I have experience in ASP.NET programming, but this is my first
dealing with Crystal Reports. I'm trying to make the most basic report
purely for testing purposes: connect to the remote SQL DB and create a
report on one of the tables. Every time I do it, I get the Logon Failed
error (CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed)
The internet search shows that this is a common problem, especially for
those using the 'pull' method. In my case it occurs in both 'push' and
'pull' methods. The problem I guess lies in the lack of credentials to
connect to the data source (DB in this case). Most solutions mentions the
SetDatabaseLogon method, but that method does not belong to the
ReportDocument object even though the documentation shows that it should.
Even with all those solutions, I still haven't managed to solve my problem!
I have a feeling I'm missing something really obvious.
To explain what exactly I'm doing. In a project, I created the
CrystalReport1.rpt file, that connects to the SQL DB by specifying the
server, username and password (not using integrated security). In the
webform I created a CrystalReportViewer instance crv. In the code behind I
put the following code:
Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument()
rpt.Load("C:\\Inetpub\\wwwroot\\TestCrystal\\CrystalReport1.rpt")
crv.ReportSource = rpt
crv.DataBind()
What exactly do I need to do here to get this report to show? Any input is
greatly appreciated.
Thanks
Milan