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

QuoteWerks Knowledgebase Topic (Article ID 6650)

Reports - Error (-2147217900) when previewing

This information applies to :

Article ID
6650

Created/Updated
August 14, 2008

Category

Are you using the most current release of QuoteWerks?
Version 24.0 Build 4
Issue:

When attempting to preview a report, user receives:

Error opening recordset in ConnOpenRecordset():
Error (-2147217900) Extra ) in query expression

Followed by:

"An error (-2147217900) was found in the SQL expression used in the search."

Cause:

There is an extra parentheses or AND/OR value at the end of the Report Filter.

Solution:

All operators must be followed by a field. Edit the report by going to Reports -> Management Reports, selecting the report and clicking Edit. Then go to the Filter tab and either remove the extra operator or add the appropriate field below it.

New Search

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