Have you looked at all of your joins and made sure that they had “Company” in them? That can make a big difference. The other thing that you can look at is adding am index to the database. (Although usually I wouldn’t expect epicor to crash, just slow down…) If you run the report and just wait (don’t click anything) does it still crash? Or will it eventually finish?
Here’s a thread where we start talking about adding an index to help a query run faster.