<div>
If you have several fields side-by-side, they don't shrink/expand in width to accommodate the data or lack there of.<br />
<br />
If you have several text fields side-by-side you could combine them in a formula like<br />
<br />
[{Namefield} + {Address1 field} + (If Not IsNull({Address2 Field}) Then {Address2 Field}) + {CityField} + &quot;, &quot;&nbsp;+ {StateField}
</div>


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}

<div>
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.
</div>


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.

Nicole Furnival

<div>
Thank you! The first option fixed it!
</div>


<div>
<div class="content wysiwyg-content">
I have written the following formula in Crystal reports. If {CnAttrCat_1.CnAttrCat_1_D<wbr />escription<wbr />} = True then &quot;&quot;&nbsp;else {CnAdrSal.CnAdrSal_Address<wbr />ee}. The problem is, when I view this information now, there are blank spaces when {CnAttrCat_1.CnAttrCat_1_D<wbr />escription<wbr />} = True. Is there a way to supress these?<br />
Thank you!
</div>
</div>


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!

Formula causing blank spaces in Crystal reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.