Accessing EnterpriseOne from Crystal Reports

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?
 
How about a few minor details like configuration and versions ...
 
I'm Developing this with Visual Studio 2003, and Crystal reports 10 for PeopleSoft. I am attempting to display the report using the Crystal report Viewer that comes with VS2003.
For EnterpriseOne I have been informed that we are using E 810.

I have been searching the web for a few days now trying to find a solution.

I am primarily a .NET developer and have almost no experience with JDE, so please let me know if I am still not providing enough information.

Thanks.
 
Accessing EnterpriseOne from Crystal Reports - Thread moved to Crystal reports

This thread has been moved/copied to the crystal reports Forum.
 
Back
Top