Distinct Sort Conflict
From Alchemex 7.1
Home > Distinct Sort Conflict
Distinct Sort Conflict
Cause: You are using an Aggregate Function on one or more display Columns and there is a Sort Field which is not selected as a display Column. It is possible to have Sort Fields which are not also Display columns but some Data Access Drivers will not support this if the an Aggregate Function is being used.
Resolution: Remove the offending Sort Fields (i.e. Sort fields which are not also selected as Display Columns).