Distinct Sort Conflict

Home > Distinct Sort Conflict

Distinct Sort Conflict

Cause: You are using the Show Distinct Rows option on the Report and you have chosen 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 most Data Access Drivers will not support this if the Show Distinct Rows option is being used.

Resolution: There are three options here to resolve the problem:

• Do not use the Show Distinct Rows option
• Remove the offending Sort Fields (i.e. Sort fields which are not also selected as Display Columns)
• Add Display Columns to correspond with all selected Sort Fields.