QuoteWerks Knowledgebase Topic (Article ID 6650)
Reports - Error (-2147217900) when previewing
This information applies to :
August 14, 2008
When attempting to preview a report, user receives:
Error opening recordset in ConnOpenRecordset():
Error (-2147217900) Extra ) in query expression
"An error (-2147217900) was found in the SQL expression used in the search."
There is an extra parentheses or AND/OR value at the end of the Report Filter.
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.
©1993-2019 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)