Results 1 to 4 of 4

Thread: Crystal Reports and JDE ODBC

  1. #1
    New Member
    Join Date
    Jul 2010
    Posts
    5

    Crystal Reports and JDE ODBC

    We have used Crystal (non enterprise) for quite awhile with Xe using the ODA ODBC driver. We recently upgraded to JDE 8.12 with tools 8.98.1. We can still use the ODA driver but have some concern that as we update the tool set we may loose conectivity. Is anybody still using the ODA driver with a tool set greater than 8.98.1? What is the best way to continue to use Crystal?


  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,250

    Re: Crystal Reports and JDE ODBC

    "What is the best way to continue to use Crystal?"

    A: Don't use ODA. Go after the database directly. You don't realize how much performance you lose using ODA (orders of magnitude). In addition ODA has the JDE limit of only 5 (?) tables in a join/query (only 3 if a outer join is used). Many of our reports have 6 - 10 tables in them. ODA can't handle that.

    What version of Crystal are you using?

    Do yourself a favor and look at Preferred Strategies solutions for JDE customers. You can leverage all your existing reports and provide users with web based reporting at the same time plus ...
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    New Member
    Join Date
    Jul 2010
    Posts
    5

    Re: Crystal Reports and JDE ODBC

    Thanks Larry

    We do realize the issues with performance using the ODA. Crystal isn't real bad but some of our people also use the ODA for Excel queries and that is a real hog!

  4. #4
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,250

    Re: Crystal Reports and JDE ODBC

    Again - check out Preferred Strategies / Business Objects. Their product includes an Office/Excel integration piece (LiveOffice).

    If you have no budget but have the time you can do what we did (search my posts on Crystal stuff).
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.