String Datatype Limitation

[nateshk]

Hi All,

I am using parameter field in my Report which is defined to be of String datatype.The report is created in ver 9.0

from my VB code iam pasing value which can be 4000 charc long. But the progran crashes.

is there any way i can overcome this limitation. is this limitation of string datatype size ?

Thanx

Natesh.

 

[dgillz]

Change the data type to memo, which has a 64,000 character limitation in v9. I believe the limitation for a string is 255. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[nateshk]

Hi dgillz ,

is the memo datatype available in report ver 9.0 ?

i tried creating a parameter field and memo datatype is not available in the drop down for datatype.

can u further elaborate, how do i do it ?

Regards

Natesh

 

[dgillz]

I do not believe that a paramter can be a memo field. Are you passing a 4,000 character parameter or a 4,000 character database field? Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

Can't say as I know the length limit for a parm in CR 9, but 4000 is likely out of bounds.

Try breaking it up into multiple parameters, you can alsways place them into a text object in the report if you need to view them as a contiguous field, and you can evaluate against multiple parms.

It's very unusual for someone to need a 4K parm.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com