1789899 - Error: Query is too complex

SAP Knowledge Base Article - Public

1789899 - Error: Query is too complex

Symptom

  • Report created in Crystal Reports version 8.5
  • The report worked as expected until it was upgraded to Crystal reports 2008 (v. 12.x)
  • Running the report in version 12.x results in the error:

Database Connector Error; 'DAO Error Code: 0xd20
Source: DAO.Database
Description: Query is too complex'

query too compex.jpg

Environment

  • Crystal Reports 2008 or later

Cause

  • The record selection formula was too long
  • The selection formula in Crystal Reports XI (11.0.x) and later has a size limit

Resolution

  • Create a Crystal Reports formula
  • Use that formula in the Selection Formula Expert

Keywords

limit bytes filter conditioni , KBA , BI-RA-CR-DSL , Crystal Reports on C++ Data Semantic Layer (ClassicUniverse) , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports, developer version for Microsoft Visual Studio