How to suppress part of the text if field is empty
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22141
Printed Date: 03 May 2024 at 10:04am
Topic: How to suppress part of the text if field is empty
Posted By: Beso90
Subject: How to suppress part of the text if field is empty
Date Posted: 11 Nov 2016 at 6:04am
|
Hello,
I have an address text box, and inside it there are the company name field, address 1, 2, 3, and city, zip, state. here: 
in most companies, there is no data in address 2 and 3, and it shows as a space and i don't want that 
also i cant eliminate those two fields from the text box because some other companies have that and the address won't be complete. I want to suppress those two lines if there's no data. How do i do that? Thanks.. |
Replies:
Posted By: DBlank
Date Posted: 11 Nov 2016 at 7:17am
|
depending on what version you are using the easiest way is:
right click on the text field select Format Text select Common Tab check 'Suppress Embedded Field Blank Lines' as True |
Posted By: Beso90
Date Posted: 11 Nov 2016 at 8:49am
| it actually worked. thanks a lot!!! |