Field Object String Length

Dear all,

I have create a parameter field in string data type under field object. I know that the maximum string length of the string data field is 255 characters. However, I would like to pass a string from the vb program to the data field with more than 255 characters and display on the crystal report. How can I do it?

Many Thanks
smchanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
The only way I have seen described to do it is to create a textbox on the report & insert the fields into the textbox.  Make it as wide as you want then set the CAN GROW option.

The other method which will not look the greatest is to stack the formula fields in the detail section and pass in fixed lengths so they fill one or more lines.  Use a fixed width font, and put 60 characters per line then pass parameters of 60, 120, 180, 0r 240 characters.

mlmcc
0
 
mlmccCommented:
Assuming you are using CR8.5 or before, you can't except by breaking it into pieces and using several formulas or textboxes for the field.

mlmcc
0
 
smchanAuthor Commented:
Thanks mlmcc,

Would you mind give me detail description on using several formulas or textboxes, since I am a greenhand on using crystal report.

ksmchan

Remarks: I am using Crystal Report 8.5
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
smchanAuthor Commented:
I have try to create a formula and concatenate the 2 parameters passing from the vb program and display the result on the report.

For example:
{?test1} + {?test2}

However the crystal report viewer returns an message "A string can be at most 254 character long".
0
 
smchanAuthor Commented:
Thanks mlmcc,

How can I insert the fields into the textbox ?
0
 
smchanAuthor Commented:
I think I can manage to do it.
Thanks mlmcc
0
 
mlmccCommented:
Glad I could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.