Adding new Table to Sales order Summary makes it run significantly slower.

Question

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?

darylbowman · Accepted Answer

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

BrendanL · Answer

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

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded