Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Field Object String Length

Posted on 2004-04-18
7
Medium Priority
?
1,844 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 101

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
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 
LVL 101

Accepted Solution

by:
mlmcc earned 500 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 101

Expert Comment

by:mlmcc
ID: 10865687
Glad I could help

mlmcc
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

927 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