Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • 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.

    Don

    Add comment
    10|10000 characters needed 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.

      Austin

  • 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

    @display

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

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

    Ian

    Add comment
    10|10000 characters needed characters exceeded