QuoteWerks Knowledgebase Topic (Article ID 6577)
Reports - SQL (-2147217900) - Duplicate sort headers
This information applies to :
August 14, 2008
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."
There are multiple sort headers in the report layout that are using the same field.
Remove the duplicate sort headers in the report layout.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)