I'm interested in what functionality Crystal Reports 10 provides in terms of complex adhoc queries. Is the only way to do this to write SQL, or is their GUI query builder capable of building queries with different combinations of intersects unions & minuses in different orders? If this can't be done with the GUI query builder, can it be done with the formula builder? Currently using Business Objects & the main thing I run into is not being able to control the order of execution of each query in a complex query containing intersects minuses, unions, etc.