asked on
Formula causing blank spaces in Crystal reports
I have written the following formula in Crystal reports. If {CnAttrCat_1.CnAttrCat_1_D
Thank you!
Thank you!
Crystal Reports
Last Comment
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
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
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 questionASKER
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
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}