Count with Perform Grouping on Server in CR 8.5

[eocea]

I am attempting to create a report that has three tables (simple view):

Project
-------
ID
Name

Locations
---------
ID
Name
ProjectID

Registrations
-------------
ID
Name
ProjectID

When I create a report that includes Locations.Name and Count(Registrations.ID) grouped by Locations.Name it returns the correct counts. However when I turn on the Perform Grouping on Server option it shows all the counts as 0. If I take the query from Show SQL Query... and run it in TOAD, SQL Plus, et al. it does show the correct output. My problem is that the query takes too long when grouping on the client.

I have used a Crystal SQL Query as a solution, but it doesn't offer me the exact flexibility I need, but it works in the short term.

Any ideas?

Thanks in advance.

 

[AlexB1234]

You might want to check your indexes to make sure that all of the fields in your joins, as well as Where/Group By clauses are covered.