Rob Woods
Member
I'm having some trouble connecting to EnterpriseOne with Crystal Reports. I have written many Crystal report applications, before, but I can not connect to the Enterprise One system.
I have created a web application that uses the Crystal reports view from Visual Studio 2003 to print reports. I am able to print reports made directly against the JDE tables with no issues, but I can not connect to the EnterpriseOne system.
I am ussing the following code to connect to the database with Crystal Reports:
Dim obj As New CrystalDecisions.CrystalReports.Engine.ReportDocument
obj.Load(Server.MapPath("ParameterTest.rpt"))
Me.CrystalReportViewer1.ReportSource = obj
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.DatabaseName = "JDEDB"
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.Password = "password"
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.ServerName = "Server12"
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.UserID = "sa"
Can anyone help?
I have created a web application that uses the Crystal reports view from Visual Studio 2003 to print reports. I am able to print reports made directly against the JDE tables with no issues, but I can not connect to the EnterpriseOne system.
I am ussing the following code to connect to the database with Crystal Reports:
Dim obj As New CrystalDecisions.CrystalReports.Engine.ReportDocument
obj.Load(Server.MapPath("ParameterTest.rpt"))
Me.CrystalReportViewer1.ReportSource = obj
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.DatabaseName = "JDEDB"
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.Password = "password"
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.ServerName = "Server12"
Me.CrystalReportViewer1.LogOnInfo(0).ConnectionInfo.UserID = "sa"
Can anyone help?