|
This is a common (and frustrating problem) when building CMS custom reports. The GROUP BY error indicates that something is wrong in the way the db query is built in your report.
The only way I have been able to eliminate this error in reports is to eliminate data items one at a time in my report until the error is cleared. Generally, I've found that the GROUP BY error has a tendency to turn up with a custom calculation that is not quite right.
|