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_D escription } = True then "" else {CnAdrSal.CnAdrSal_Address ee}. The problem is, when I view this information now, there are blank spaces when {CnAttrCat_1.CnAttrCat_1_D escription } = True. Is there a way to supress these?
Thank you!
Thank you!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you! The first option fixed it!
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}