Avatar of Nicole Furnival
Nicole Furnival
 asked on

Formula causing blank spaces in Crystal reports

I have written the following formula in Crystal reports. If {CnAttrCat_1.CnAttrCat_1_Description} = True then "" else {CnAdrSal.CnAdrSal_Addressee}. The problem is, when I view this information now, there are blank spaces when {CnAttrCat_1.CnAttrCat_1_Description} = True. Is there a way to supress these?
Thank you!
Crystal Reports

Avatar of undefined
Last Comment
Nicole Furnival

8/22/2022 - Mon
Mike McCracken

If you have several fields side-by-side, they don't shrink/expand in width to accommodate the data or lack there of.

If you have several text fields side-by-side you could combine them in a formula like

[{Namefield} + {Address1 field} + (If Not IsNull({Address2 Field}) Then {Address2 Field}) + {CityField} + ", " + {StateField}
Nicole Furnival

ASKER
The only field in the report is the one addressee field. When the report is previewed, many of the lines are blank and the blank fields take up a line, so there are random spaces in the report, I know I have encountered this problem before, something about if Isnull, but I cannot remember where I add this in the details section, any help would be appreciated.
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Nicole Furnival

ASKER
Thank you! The first option fixed it!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23