Crystal Report String Parameter max length

[Former Member]

Can someone please confirm the max length of string parameter in Crystal Reports?

Thanks,

Syed

[vitaly_izmaylov · Accepted solution]

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.  

[Former Member · Accepted solution]

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

[vitaly_izmaylov · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks Vitaly.

[vitaly_izmaylov · Accepted solution]

56K works as well

[former_member11696]

not a db question. moved to Design forum

[former_member11696]

May be 256 or could be 512 but it could also be 1K. Depends on the version of CR Designer you are using.

If you need to use strings longer than that you may want to redesign the report and parameter

[jyothirmayee_s]

Hi,

Maximum is 65k chars.

Thanks,

Jothi