<div>
Change &quot;and&quot; to &quot;OR&quot;
</div>


<div>
Thanks for the answer<br />
<br />
I have changed it to or and get the following error message<br />
<br />
An expression of non-boolean type specified in a context where a condition is expected near a ','
</div>


Thanks for the answer

I have changed it to or and get the following error message

An expression of non-boolean type specified in a context where a condition is expected near a ','

<div>
If that doesn't help, post the new formula.<br />
<br />
If this is part of the selection formula then please post the full formula.<br />
<br />
mlmcc
</div>


If that doesn't help, post the new formula.

If this is part of the selection formula then please post the full formula.

mlmcc

<div>
You're welcome. &nbsp;FWIW, Ido really deserves some of the points, because he posted part of the solution. &nbsp;If you like, you can ask to have the question re-opened and then split the points between us.<br />
<br />
&nbsp;James
</div>


You're welcome.  FWIW, Ido really deserves some of the points, because he posted part of the solution.  If you like, you can ask to have the question re-opened and then split the points between us.

 James

<div>
<div class="content wysiwyg-content">
I am using CR2008<br />
<br />
I using a SQL command in my report.<br />
<br />
I have a number values in a parameter and it allows multiple values<br />
<br />
The synatx is as follows<br />
<br />
where (MA_SchemeID IN {?Scheme} and {?Scheme} &nbsp;= 0)<br />
<br />
I am using {?Scheme} &nbsp;= 0 to bring back all values, but this is not working<br />
<br />
Can anybody help with the correct syntax?<br />
<br />
Thanks
</div>
</div>


I am using CR2008

I using a SQL command in my report.

I have a number values in a parameter and it allows multiple values

The synatx is as follows

where (MA_SchemeID IN {?Scheme} and {?Scheme}  = 0)

I am using {?Scheme}  = 0 to bring back all values, but this is not working

Can anybody help with the correct syntax?

Thanks

Parameters - bring all values back

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.