<div>
I gave pssandhu 450 points because that was the first correct answer. &nbsp;I gave 50 to mlmcc because that may be what I saw before and it's good to know that it's equivalent. &nbsp;Thank you both very much.
</div>


I gave pssandhu 450 points because that was the first correct answer.  I gave 50 to mlmcc because that may be what I saw before and it's good to know that it's equivalent.  Thank you both very much.

<div>
<div class="content wysiwyg-content">
I just need the exact code to specify the following (in a sort-of pseudocode)<br />
<br />
if DBfield is in (&quot;ABC&quot;, &quot;XYZ&quot;,&quot;RST&quot;) then &nbsp; &nbsp; &lt;-- This is the problem<br />
&nbsp; do something<br />
else<br />
&nbsp; do something else<br />
<br />
I can't find how to specify the IN. &nbsp;IN RANGE doesn't work. &nbsp;I saw it somewhere else where it had IN and then there was another keyword after the list of values and before the THEN, but I can't find it. &nbsp;Help!
</div>
</div>


I just need the exact code to specify the following (in a sort-of pseudocode)

if DBfield is in ("ABC", "XYZ","RST") then     <-- This is the problem
  do something
else
  do something else

I can't find how to specify the IN.  IN RANGE doesn't work.  I saw it somewhere else where it had IN and then there was another keyword after the list of values and before the THEN, but I can't find it.  Help!

Crystal reports IF &lt;VALUE&gt; IN &lt;LIST OF VALUES&gt; THEN DO SOMETHING

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.

Crystal reports IF &lt;VALUE&gt; IN &lt;LIST OF VALUES&gt; THEN DO SOMETHING

Crystal reports IF <VALUE> IN <LIST OF VALUES> THEN DO SOMETHING