<div>
Personally I always found it a bit easier to use IIF. &nbsp; It doesn't change the logic, but I always found it easier to read (and I never lost a parenthesis.<br />
<br />
Also, I see that you switch between + and &amp;. &nbsp;You will want to stay consistent<br />
<br />
+ IIF( {@GiftNote} &gt;&nbsp;&quot; &quot;, &quot;Gift Note: &quot;&nbsp;+ {@GiftNote} + chrw(13) + chrw(10) , &quot;&nbsp;&quot;)<br />
+ IIF( sum({GIFT.PREM_VAL})&gt;0, &nbsp;&quot;Premium Value: $&quot; + cstr(sum({GIFT.PREM_VAL}))<wbr /> + chrw(13) + chrw(10), &quot;&nbsp;&quot;)<br />
+ IIF( {WILL.CSV}&gt;0, &quot;Charitable Deduction: $&quot; &amp;&nbsp;cstr({WILL.CSV} ) , &quot;&nbsp;&quot;)
</div>


Personally I always found it a bit easier to use IIF.   It doesn't change the logic, but I always found it easier to read (and I never lost a parenthesis.

Also, I see that you switch between + and &.  You will want to stay consistent

+ IIF( {@GiftNote} > " ", "Gift Note: " + {@GiftNote} + chrw(13) + chrw(10) , " ")
+ IIF( sum({GIFT.PREM_VAL})>0,  "Premium Value: $" + cstr(sum({GIFT.PREM_VAL})) + chrw(13) + chrw(10), " ")
+ IIF( {WILL.CSV}>0, "Charitable Deduction: $" & cstr({WILL.CSV} ) , " ")

<div>
Thank you! I've been fighting this for hours...so simple...wish I'd have thought of it.
</div>


Thank you! I've been fighting this for hours...so simple...wish I'd have thought of it.

<div>
<div class="content wysiwyg-content">
The following expression does not return any data after the giftnote. I been making subtle changes and trying different things, but can't get it to work. I have set default values for nulls. I have tried with and without else.<br />
<br />
&quot;Gift designation: &quot;&nbsp;+ {FUND.FUND_TITLE}+ &quot;&nbsp;(Fund number: &quot;&nbsp;+ {GIFT.FUND_ACCT} + &quot;)&quot; <br />
+ chrw(13) + chrw(10) <br />
+ if {@GiftNote} &gt;&nbsp;&quot;&quot; then &quot;Gift Note: &quot;&nbsp;+ {@GiftNote} + chrw(13) + chrw(10) else &quot;&quot;<br />
&amp;&nbsp;if sum({GIFT.PREM_VAL})&gt;0 then &quot;Premium Value: $&quot; + cstr(sum({GIFT.PREM_VAL}))<wbr /> &amp;&nbsp;chrw(13) &amp;&nbsp;chrw(10) else &quot;&quot;<br />
&amp;&nbsp;if {WILL.CSV}&gt;0 then &quot;Charitable Deduction: $&quot; &amp;&nbsp;cstr({WILL.CSV} )else &quot;&quot;
</div>
</div>


The following expression does not return any data after the giftnote. I been making subtle changes and trying different things, but can't get it to work. I have set default values for nulls. I have tried with and without else.

"Gift designation: " + {FUND.FUND_TITLE}+ " (Fund number: " + {GIFT.FUND_ACCT} + ")" 
+ chrw(13) + chrw(10) 
+ if {@GiftNote} > "" then "Gift Note: " + {@GiftNote} + chrw(13) + chrw(10) else ""
& if sum({GIFT.PREM_VAL})>0 then "Premium Value: $" + cstr(sum({GIFT.PREM_VAL})) & chrw(13) & chrw(10) else ""
& if {WILL.CSV}>0 then "Charitable Deduction: $" & cstr({WILL.CSV} )else ""

Chrystal report expression

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.