PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Jeffrey Ferreira on October 19, 2021, 11:04:36 AM

Title: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
Post by: Jeffrey Ferreira 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
Title: Re: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
Post by: Stéphane Devouard 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,
Title: Re: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
Post by: GBorleis85 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.