1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. Report Generated by Wizard Generates error “A column has been specified more than once in the order by list. Columns in the order by list must be unique” – BACKTRACK error report

Report Generated by Wizard Generates error “A column has been specified more than once in the order by list. Columns in the order by list must be unique” – BACKTRACK error report

Summary

This Error Message Article explains the BACKTRACK error message “A column has been specified more than once in the order by list. Columns in the order by list must be unique” and details how to fix the underlying problem that caused it to appear.

Explanation

The error message points to an error in the SQL statement generated by the reporting wizard. There are duplicate entries in the ORDER BY section of the statement.

Solution

This appears to be a software defect within the report writer module. The way to sidestep this issue is to not include the ‘sort by’ option in the wizard. Then after saving the report, use the Advanced Designer feature, and set the sorting order by editing the Data band.

Additional Comments

 

Updated on September 26, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support