Maximum String Parameter Length

[Guest_imported]

I am passing a string parameter via a stored procedure. What is the maximum length Crystal can accept for a string parameter and if it is not greater than 254, is there any way to increase the length that crystal will accept ?

 

[paulmarr]

NovaAndy,

Yes - it is 254 - and the only way I know is to break up the string parameter into parts and then concatinate them in a formula.

Hope this helps

paulmarr

 

[AndyNova]

Thanks for the info...I think I can break it up in ASP but am a little confused about how the stored procedure will accept it - does this mean I add an extra parameter to the sproc, and if so, can you dynamically create parameters within a sproc ? As it is now I have defined 4 parameters, 2 dates, one for clients and another for users. When they select "x" number of clients and the string is > 254, your saying break it up, pass an extra parameter ? I'll give it a try - thanks !