407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6577)

Reports - SQL (-2147217900) - Duplicate sort headers

This information applies to :

Article ID
6577

Created/Updated
August 14, 2008

Category


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:
Report gives the following error:
"An error (-2147217900) was found in the SQL expression used in the search.
The error returned was:
A column has been specified more than once in the order by list. Columns in the order by list must be unique."

Cause:
There are multiple sort headers in the report layout that are using the same field.

Solution:
Remove the duplicate sort headers in the report layout.

New Search