In Crystal Reports 9 and above, the Add Command function is used to create a SQL command (such as a SQL query).
What is the maximum size for a SQL command?
- Crystal Reports
- Crystal Reports for Visual Studio
The maximum size for a SQL command is 64 KB. If your SQL command is larger than 64 KB, we recommend using a stored procedure.
For more information on the Add Command function, download cr_query_engine.pdf from the Business Objects support site at http://support.businessobjects.com/search.
ADD COMMAND SQL QUERY LIMIT MAX BIGGEST SIZE CR CR9 CR10 CUSTOMIZE CUSTOMIZED Crystal Reports Add Command SQL Query Maximum , c2015231 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem