PxPlus User Forum
Main Board => Discussions => ODBC => Topic started 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
-
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,
-
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.