Solved

Field Object String Length

Posted on 2004-04-18
7
1,642 Views
Last Modified: 2007-12-19
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
0
Comment
Question by:smchan
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 10856215
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
 

Author Comment

by:smchan
ID: 10856331
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
 

Author Comment

by:smchan
ID: 10857319
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Accepted Solution

by:
mlmcc earned 125 total points
ID: 10859367
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
 

Author Comment

by:smchan
ID: 10864961
Thanks mlmcc,

How can I insert the fields into the textbox ?
0
 

Author Comment

by:smchan
ID: 10865035
I think I can manage to do it.
Thanks mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 10865687
Glad I could help

mlmcc
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now