Report Error: "Multi-level GROUP BY clause is not allowed in a subquery."

[Tom]

Hi,

I need some help with fixing the following report error: "Multi-level GROUP
BY clause is not allowed in a subquery."

Here's what I had thus far (this process never threw the error):
========================================
1. "QueryB" has datasource of "QueryA"
2. "QueryB" is make-table query... when executed, it creates "TableA".
3. "QueryB" has 2 sub-Selects such as:

Division: (SELECT MIN(Division) FROM QueryA)
Branch: (SELECT MIN(Branch) FROM QueryA)

4. "QueryC" has datasource of "TableA"
5. "ReportA" has datasource of "QueryC"

Again, this process was working ok (meaning, I didn't get the report error)
but it had to be changed due to multiple-user login (the make-table queries
prevented some db functionality).


Here's the new structure:
================
1. "QueryB" has datasource of "QueryA"
2. "QueryB" is now a select query
3. "QueryB" has 2 sub-Selects such as:

Division: (SELECT MIN(Division) FROM QueryA)
Branch: (SELECT MIN(Branch) FROM QueryA)

4. "QueryC" has datasource of "QueryB"
5. "ReportA" has datasource of "QueryC"


Now, once I open up the ReportA, I get the error as listed above. If I
replace e.g. "Division: (SELECT MIN(Division) FROM QueryA)" with "Division"
the error doesn't occur. However, without the subselect, I sometimes don't
see expected data on report (missing data is not really relevant to the
problem-solving though).

My question now: How can I overcome the report error while still using the
subselect in QueryB?


Thanks,
Tom