<div>
You can also do it from the Report Expert, by choosing the last option, &quot;Formula&quot;, in the drop down.<br />
You can then enter the criteria such as what Pete as posted. &nbsp;<br />
<br />
BTW, I am sure it was a typo, but Pete's formula will need a closing parenthesis at the end.
</div>


You can also do it from the Report Expert, by choosing the last option, "Formula", in the drop down.
You can then enter the criteria such as what Pete as posted.  

BTW, I am sure it was a typo, but Pete's formula will need a closing parenthesis at the end.

<div>
Glad i could help<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm new to Crystal, and in version 8.5, when I get to the portion of the Report Expert Wizard that lets me define my selection critieria, I can't seem to find how I can perform IS NULL or IS NOT NULL criteria. &nbsp;I select a field, but the values that appear in the critieria box (is a value, is not equal to, is gretaer than, etc) does not include IS NULL or IS NOT NULL. &nbsp;I know there has to be a way to do this, so maybe I am just missing it.<br />
<br />
Thanks,<br />
Chris
</div>
</div>


Hello,

I'm new to Crystal, and in version 8.5, when I get to the portion of the Report Expert Wizard that lets me define my selection critieria, I can't seem to find how I can perform IS NULL or IS NOT NULL criteria.  I select a field, but the values that appear in the critieria box (is a value, is not equal to, is gretaer than, etc) does not include IS NULL or IS NOT NULL.  I know there has to be a way to do this, so maybe I am just missing it.

Thanks,
Chris

How can you add IS NOT NULL or IS NULL critieria in Crystal 8.5

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.