Solved

Crystal reports trimming spaces at the end of fields.

Posted on 2004-03-31
5
364 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:FTIISD
  • 3
5 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 10727084
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;

================================

0
 
LVL 42

Expert Comment

by:frodoman
ID: 10727093
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;

================================
0
 

Author Comment

by:FTIISD
ID: 10727138
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.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 10727232
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.


0
 
LVL 100

Expert Comment

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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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 …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

777 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