SAP Knowledge Base Article - Public

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


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


  • Crystal Reports 2008
  • Crystal Reports XI R2


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


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.


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


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