An official string, text, memo field, command object sql limit in Crystal Reports is always 64K.
I do remember testing more than 1K string parameter passing to a stored procedure. User used parameter to pass custom SQL statement. If this is your case please remove all line breaks or other formating symbols from the string and make sure the custom SQL does not change the whole stored procedure records set.
Thanks all for reply, just to explain more about requirement.
My requirement is that an application need to pass a comma separated values/ID's '1,2,3....'
in one string and report need to be generate for each of ID and export to PDF.
process is working fine except my team want to know the maximum length of character can be passed. we are using Crystal report 2008 and version is 220.127.116.11.
I passed a string parameter i.e. '1,2,3.....1000' which had length of around 3998 and report does work.
so not sure what is the limit as passing more than 3998 character length parameter is seems not working.
Vitaly says range string, text, memo field, command object sql limit in Crystal Reports is always 64K, however seems not true for parameters.
I mentioned the size of SQL command object for a reason, because if your parameter is a part of records selection formula, then the whole parameter string would be added to your sql string.
You would be limited not by parameter size, but the whole SQL size.
I just tested 7K size parameter and it still works.