Skip to Content

How to trim the space between fields in report (VS 2017)

Feb 23 at 09:22 PM


avatar image
Former Member

Hi all,currently I have a trouble in trimming the space between fields,here's the example;

The "DOC" and "659" is too far away and "MAXM" and "1343F" is at suitable space.

The label should be like this:

I tried to check the "suppress blank space" option but it didn't work. What can I do?

The designer:

Thx all.

擷取.png (1.7 kB)
擷取.png (7.1 kB)
擷取.png (1.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Don Williams
Feb 23 at 09:26 PM

Hi Austin,

I changed the tag to CR Designer. You can use a formula to remove the space.

Click the F1 key in CR Designer and it will bring up Crystals Help file, you can search for removing spaces in it.


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Don,

thanks for your reply. I Google couple of times and the results is nothing. Because all of them are just trimming space in the fields.
I'm trying to trimming the gap between fields. I guest the formula is just affect the fields. not for the gap.


Ian Waterman Feb 26 at 12:10 PM

If you want to control appearance you will need to combine fields into a single formula

Assuming Numbers are number data types then your formula will look like following, if numbers ate numeric text fields then you will not need the totext() function


{DocField}&" "&totext({659field},0,"")&" "&totext({51field},0,"")&" "&totext({4field},0,"")

Arguments 0, "" ensure no decimals and no thousand separator


10 |10000 characters needed characters left characters exceeded