Avaya CMS/CentreVu Reprts

[pkenagy2]

I am attempting to build a new custom report, and once it's built and the queries are built and I attempt to "RUN" it, I get an error back saying that my query c_1 needs to be in the GROUP BY list. I cannot find reference to GROUP BY list and/or where to add it. It is a new data item that appears to be the problem that I added to the dictionary. Thanks for any assistance anyone can offer.

[MHawkins]

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.

[felix]

I'll be glad to help you out with your report, if you can paste the query string here, i'll be glad to take a loot at it, and see if there is any problem with it.