<div>
Close.<br />
<br />
Because EarnCode is a number, you need to decide if you want this to return a number or a string. &nbsp;My guess is you don't care.<br />
<br />
Try it this way:<br />
<br />
if {brptPRRegister;1.EarnCode<wbr />} in [125, 126, 401] then &quot;&quot;<br />
else Cstr({brptPRRegister;1.Ear<wbr />nCode},0)<br />

</div>


<div>
on the last part where you put in the zero, how can you fix that if what you are evaluating is a null? so that a null just shows...or blank, really?
</div>


<div>
if IsNull({brptPRRegister;1.E<wbr />arnCode}) or {brptPRRegister;1.EarnCode<wbr />} &nbsp;in [125, 126, 401] then &quot;&quot;<br />
else Cstr({brptPRRegister;1.Ear<wbr />nCode},0)<br />

</div>


<div>
I still have a zero showing up. hhhmmmm
</div>


<div>
awesome!!! Thanks and thanks for so fast!!!
</div>


<div>
<div class="content wysiwyg-content">
I have this as code in a formula:<br />
<br />
if {brptPRRegister;1.EarnCode<wbr />} in [125, 126, 401] then &quot;&quot;<br />
else {brptPRRegister;1.EarnCode<wbr />}<br />
<br />
what I want is for the result of this field NOT to include 125, 126 or 401, but everything else. The<br />
field {brptPRRegister;1.EarnCode<wbr />} is a number type.<br />
<br />
The error I get is the part after the &quot;else&quot; gets highlighted and says a string is required here. Am I even writing this properly to get what I want?<br />
<br />

</div>
</div>


I have this as code in a formula:

if {brptPRRegister;1.EarnCode} in [125, 126, 401] then ""
else {brptPRRegister;1.EarnCode}

what I want is for the result of this field NOT to include 125, 126 or 401, but everything else. The
field {brptPRRegister;1.EarnCode} is a number type.

The error I get is the part after the "else" gets highlighted and says a string is required here. Am I even writing this properly to get what I want?



Crystal Reports XI - syntax question If, then else

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.