Application Analyst

PresidentLincoln

<div>
@James thanks. &nbsp;I was way off on this one. &nbsp;<br><br>
</div>


@James thanks.  I was way off on this one.  



<div>
&nbsp;You're welcome. &nbsp;Glad I could help.<br><br>&nbsp;James
</div>


 You're welcome.  Glad I could help.

 James

<div>
<div class="content wysiwyg-content">
I am attempting to use a formula for a group, so the group header will be conditional based on a specific setting. &nbsp;Here's what I have:<br />
<br />

<pre><code id="code-10-29184103-1">if {Command.PRODUCT} in ('Auto Loan','Boat Loan','Motorcycle Loan',) then {Command.HEADER}=&quot;Vehicle Loan&quot; else {Command.HEADER}</code></pre>
<br />
The idea is if the PRODUCT is any of those 3 types of loans, the group header will be &quot;Vehicle Loan&quot;, otherwise it will be the default. &nbsp; The problem is I keep getting this error:<br />
<br />

<pre><code id="code-10-29184103-2">The ) is missing.</code></pre>
<br />
I know this is a syntax issue, but I can't figure out what to do to fix it. &nbsp;Any assistance would be appreciated.
</div>
</div>


I am attempting to use a formula for a group, so the group header will be conditional based on a specific setting.  Here's what I have:

(CODE)

The idea is if the PRODUCT is any of those 3 types of loans, the group header will be "Vehicle Loan", otherwise it will be the default.   The problem is I keep getting this error:

(CODE)

I know this is a syntax issue, but I can't figure out what to do to fix it.  Any assistance would be appreciated.

Crystal Reports - Help with if...then...else formula

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.