1574977 - How to use the SQL larger than 64KB in Command Object of Crystal Reports?

SAP Knowledge Base Article - Public

1574977 - How to use the SQL larger than 64KB in Command Object of Crystal Reports?

Symptom

How to adjust the sql query in the command object, when the size of query is greater than 64 KB? 

Environment

  • Crystal Reports 2008
  • Crystal Reports XI R2

Cause

There is a limitation of writing the sql query upto 64KB in Command Object.

Resolution

If size of the query exceeds 64KB then it is suggested to use the following Workaround:

  1. Use Stored Procedures and execute from Command Object
  2. Two command Objects can be created and then linked.


Keywords

Command Object, Sql query, Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2