PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables  (Read 1557 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
« on: October 19, 2021, 11:04:36 AM »
Hello All

I have a client that does the following using Crystal and PxPlus ODBC Driver:

-> Links Order Header to Order Lines (works fine)
-> Links Order Lines to Inventory Master (works fine)
-> Links Order Header to Order Lines and Order Lines to Inventory Master (fails)

I don't know if it is a Crystal Problem or a PxPlus ODBC problem. Has anyone else had an issue like this

jeff

Stéphane Devouard

  • Diamond Member
  • *****
  • Posts: 122
  • PxPlus guru with skills in PHP, JS, C#, Java
    • View Profile
    • Stéphane's Web Resume
Re: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
« Reply #1 on: October 19, 2021, 11:47:12 AM »
Hi Jeff


Haven’t done much Crystal and PxPlus ODBC, but :
How about linking order lines to order header and inventory master ?
Would be two inner joins to the main table instead of one left join then one inner join


Just thinking out loud


Regards,
Stéphane Devouard
Portfolio | Work

GBorleis85

  • New Member
  • *
  • Posts: 2
    • View Profile
Re: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
« Reply #2 on: October 20, 2021, 02:51:22 PM »
In my experience Crystal does not do joins well. They cause performance slow downs. The more joins the worse it gets. Our solution was to do the joins in code and write the results to a table that Crystal could simply read.