<div>
use paranthesis<br />
<br />
({@Debtor Indicator} &lt;&gt;&nbsp;&quot;&quot;) or ({@EEC Indicator} &lt;&gt;&nbsp;&quot;&quot;)
</div>


use paranthesis

({@Debtor Indicator} <> "") or ({@EEC Indicator} <> "")

<div>
IF {@Debtor Indicator} &lt;&gt;&nbsp;&quot;&quot; or IF {@EEC Indicator} &lt;&gt;&nbsp;&quot;&quot;
</div>


IF {@Debtor Indicator} <> "" or IF {@EEC Indicator} <> ""

<div>
Sorry, Neither of the above suggestions work. I have already tried to use parenthesis and this makes no difference - again either of the two formulas work on their own, but not in combination.<br />
<br />
I have also previously tried using the 'IF' function, but this returns an error - 'the keyword 'then' is missing' 
</div>


Sorry, Neither of the above suggestions work. I have already tried to use parenthesis and this makes no difference - again either of the two formulas work on their own, but not in combination.

I have also previously tried using the 'IF' function, but this returns an error - 'the keyword 'then' is missing'

<div>
Glad I could help.<br />
<br />
Spykair
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I'm sure that this is a really basic problem, but I can't seem to get it to work. Basically, I want to suppress &nbsp;subreport on the basis of either of two reports being null. The formula I have is:<br />
<br />
{@Debtor Indicator} &lt;&gt;&nbsp;&quot;&quot; or {@EEC Indicator} &lt;&gt;&nbsp;&quot;&quot;<br />
<br />
Either of these works fine, but in combination they don't work. How do I combine them so that the subreport is suppressed if either of the above conditions is met?<br />
<br />
Many thanks,
</div>
</div>


Hi

I'm sure that this is a really basic problem, but I can't seem to get it to work. Basically, I want to suppress  subreport on the basis of either of two reports being null. The formula I have is:

{@Debtor Indicator} <> "" or {@EEC Indicator} <> ""

Either of these works fine, but in combination they don't work. How do I combine them so that the subreport is suppressed if either of the above conditions is met?

Many thanks,

Using the 'or' operand

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.