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:
- Use Stored Procedures and execute from Command Object
- 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