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.