Solved

Field Object String Length

Posted on 2004-04-18
7
1,757 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
LVL 101

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 101

Expert Comment

by:mlmcc
ID: 10865687
Glad I could help

mlmcc
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

615 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