Skip to main content

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?

 

 

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


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 @darylbowman implementing that fixed the issue, it only takes a few seconds to run the report now rather than a minute or more.


Reply