I've tried adding every field to the GROUP BY. Part of the problem is that some of the column names are being aliased (I've got a CASE/WHEN in place because this is pulling data for one of three types of jobs: Application, Software, or Server. The CASE/WHENs both end with the alias name.)
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".