on 05-01-2013 2:53 PM
Can someone please confirm the max length of string parameter in Crystal Reports?
Thanks,
Syed
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 12.4.0.96.
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.
Thanks
Syed
Syed,
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.
not a db question. moved to Design forum
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Maximum is 65k chars.
Thanks,
Jothi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.