May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Course Of The Month
8 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Crystal reports trimming spaces at the end of fields.
Posted on 2004-03-31
Hi,
I am placing multiple fields into a text box. These each of these fields in the database contain a space at the end. For some reason crystal reports is removing these spaces. I need it to place a space between each of the fields. I attempted to put a space in the text box between the fields, but if the field is blank it will leave two spaces.
Thanks
I am placing multiple fields into a text box. These each of these fields in the database contain a space at the end. For some reason crystal reports is removing these spaces. I need it to place a space between each of the fields. I attempted to put a space in the text box between the fields, but if the field is blank it will leave two spaces.
Thanks
[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
3
5 Comments
That's going to be tough to overcome with a text box because you have little or no control over how Crystal formats it.
I would consider instead creating a formula so you can control the results. Something along these lines:
==========================
stringVar MyResult := '';
If trim({table.field1}) <> '' Then
MyResult := {table.field1};
If trim({table.field2}) <> '' Then
MyResult := ' '+{table.field2};
If trim({table.field3}) <> '' Then
MyResult := ' '+{table.field3};
...etc...
MyResult;
==========================
I would consider instead creating a formula so you can control the results. Something along these lines:
==========================
stringVar MyResult := '';
If trim({table.field1}) <> '' Then
MyResult := {table.field1};
If trim({table.field2}) <> '' Then
MyResult := ' '+{table.field2};
If trim({table.field3}) <> '' Then
MyResult := ' '+{table.field3};
...etc...
MyResult;
==========================
Sorry for the typo, should actually be:
==========================
stringVar MyResult := '';
If trim({table.field1}) <> '' Then
MyResult := {table.field1};
If trim({table.field2}) <> '' Then
MyResult := MyResult+' '+{table.field2};
If trim({table.field3}) <> '' Then
MyResult := MyResult+' '+{table.field3};
...etc...
MyResult;
==========================
==========================
stringVar MyResult := '';
If trim({table.field1}) <> '' Then
MyResult := {table.field1};
If trim({table.field2}) <> '' Then
MyResult := MyResult+' '+{table.field2};
If trim({table.field3}) <> '' Then
MyResult := MyResult+' '+{table.field3};
...etc...
MyResult;
==========================
Is there any other way to do this? Is there a reason that crystal reports is removing these spaces? I have an extremely long reports, and this method will take a long time.
Thanks.
Thanks.
I have no idea "why" but it's not even consistent between versions.
How long your report is doesn't matter as much as how many fields you're combining into a single text box. I don't know of an easier way to do this. Honestly I usually just put the space between the fields and ignore the extra spaces when they happen - I use a variable width font so you have to really look closely to see the difference between one space and two anyway.
How long your report is doesn't matter as much as how many fields you're combining into a single text box. I don't know of an easier way to do this. Honestly I usually just put the space between the fields and ignore the extra spaces when they happen - I use a variable width font so you have to really look closely to see the difference between one space and two anyway.
Active today
The formula idea will work for CR9 and 10. For earlier versions so long as the text doesn't exceed 255 characters it will work.
The inserting into a text box is the method for getting around the ength limitation.
I agree with frodoman, if single vs double space is important use the formula.
mlmcc
The inserting into a text box is the method for getting around the ength limitation.
I agree with frodoman, if single vs double space is important use the formula.
mlmcc
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Crystal Reports Date Calculation | 10 | 52 | |
| Crystal Reports 7 VB6 'Feature Not Enabled' Error | 10 | 41 | |
| Count The Number of Parameter Values entered in a Mult Selection Parameter Dialog Box | 4 | 39 | |
| Crystal Reports, A month number | 14 | 42 |
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…
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…
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 …
Suggested Courses
Course of the Month8 days, 10 hours left to enroll
738 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.