Solved

Field Object String Length

Posted on 2004-04-18
7
1,710 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
Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

685 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