407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
Customer Area

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 24.0 Build 2
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

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)