Multi-level Group By Error
UtterAccess Discussion Forums
Feb 23 2011, 05:51 PM
I have a report that I'm trying to create that has 4 report group by(s), but I keep getting the above mentioned error.
If I remove all of the report group by(s) from the report the error goes away.
Feb 23 2011, 09:53 PM
Never seen that error before, can you post a picture of your report in design view with the group by details?
Feb 24 2011, 12:02 PM
I see what was causing the problem,
The underlying query was coalescing two correlated sub-queries.
So, Basically the report doesn't like:
SELECT NZ( ( SELECT ... ), ( SELECT ... )) AS result_column, ...
when report group-by(s) are applied.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please