I added the SOShippingAddress table with the Inner join type to the SOOrder parent table. this was done as I am making a copy of the report but one that tracks ship to address data for country, city and state. after doing so the report goes from loading in seconds to taking a minute or longer to load.
is there a better way to do this join so it doesn’t take so long to run and parse data?
Best answer by darylbowman
Take another look at the join conditions. You're joining [SOOrder] OrderType to SOOrder.OrderType and [SOOrder] OrderNbr to SOOrder.OrderNbr.
You need to join [SOOrder] ShipAddressID to [SOShippingAddress] AddressID
+15Take another look at the join conditions. You're joining [SOOrder] OrderType to SOOrder.OrderType and [SOOrder] OrderNbr to SOOrder.OrderNbr.
You need to join [SOOrder] ShipAddressID to [SOShippingAddress] AddressID
Take another look at the join conditions. You're joining [SOOrder] OrderType to SOOrder.OrderType and [SOOrder] OrderNbr to SOOrder.OrderNbr.
You need to join [SOOrder] ShipAddressID to [SOShippingAddress] AddressID
thank you very much
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
