cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

@display

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

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

Ian

0 Kudos

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.

Don

Former Member
0 Kudos

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.

Austin