We help IT Professionals succeed at work.

Removing data lines

Gordon Hughes
on
106 Views
Last Modified: 2018-10-02
I have a crystal report
With some fields that do not contain data
I would like to suppress these and move other data up in it's place
Ie
Address 1
Address 2
Town

so I may not have any data for address2 so rather than a gap, can I then see, with no gap
Address1
Town

Gordon
Comment
Watch Question

Senior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Gordon HughesDirector

Author

Commented:
Hi Eric
Do I create a new formula for this and if so where do I put it?
Gordon
Éric MoreauSenior .Net Consultant
CERTIFIED EXPERT
Top Expert 2016

Commented:
yes you need to create a new formula. check https://kb.blackbaud.com/articles/Article/41726
Raghavendra HullurSoftware Developer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Gordon HughesDirector

Author

Commented:
All
Thanks for your support
Gordon
CERTIFIED EXPERT

Commented:
FWIW, if you put the fields in separate sections (with nothing else in the section), then you should be able to just use the "Suppress blank section" option in the Section Expert to suppress those sections, rather than creating a suppression formula.  Either one works.  "Suppress blank section" is just a bit easier.

 James
Gordon HughesDirector

Author

Commented:
Hi James
That is what I am doing
Thanks
Gordon
Raghavendra HullurSoftware Developer
CERTIFIED EXPERT

Commented:
Well, if there is nothing else in that section, then what James suggested would definitely work.
But, in case, you want to display a label for each of those fields, then the section won't be blank.
That's why I suggested to use section expert level suppression.