<div>
sorry...v!0 connected to MS SQL 7.0 on Win2k
</div>


sorry...v!0 connected to MS SQL 7.0 on Win2k

<div>
You must have the syntax set to Basic in the drop down in the upper right of the formula workshop.<br />
Change that drop down to Crystal syntax and that should clear up that error.
</div>


You must have the syntax set to Basic in the drop down in the upper right of the formula workshop.
Change that drop down to Crystal syntax and that should clear up that error.

<div>
Thanks, Dave...that looks like it got it...appreciate the quick response!
</div>


Thanks, Dave...that looks like it got it...appreciate the quick response!

<div>
I was using the Basic syntax, but missed explicitly stating the formula.
</div>


I was using the Basic syntax, but missed explicitly stating the formula.

<div>
If I switch to Basic Syntax and type &quot;Formula = {crBodyText}<br />
<br />
the result is &quot;This field name is not known.&quot; yet I am pretty sure this field (crBodyText) does exist in the report!
</div>


If I switch to Basic Syntax and type "Formula = {crBodyText}

the result is "This field name is not known." yet I am pretty sure this field (crBodyText) does exist in the report!

<div>
Sorry - posted to wrong question - PLEASE IGNORE!! &nbsp; &nbsp;:D
</div>


Sorry - posted to wrong question - PLEASE IGNORE!!    :D

<div>
<div class="content wysiwyg-content">
Greetings...I'm new to crystal and trying to execute the following code to color a textbox, but I get &quot;The special variable 'Formula' must be assigned a value within the formula&quot;. What can I do to resolve this?<br />
<br />
Scott<br />
<br />
If {Total} &nbsp;&lt; &nbsp;({Average}/2) Then<br />
&nbsp; &nbsp; crRed<br />
ElseIf {Total} &nbsp;&gt;= &nbsp;({Average}/2) And {Total} &nbsp;&lt; &nbsp;{Average} Then<br />
&nbsp; &nbsp; crYellow<br />
ElseIf {Total} &nbsp;&gt;= &nbsp;{Average} Then<br />
&nbsp; &nbsp; crGreen<br />
End If
</div>
</div>


Greetings...I'm new to crystal and trying to execute the following code to color a textbox, but I get "The special variable 'Formula' must be assigned a value within the formula". What can I do to resolve this?

Scott

If {Total}  <  ({Average}/2) Then
    crRed
ElseIf {Total}  >=  ({Average}/2) And {Total}  <  {Average} Then
    crYellow
ElseIf {Total}  >=  {Average} Then
    crGreen
End If

The special variable 'Formula' must be assigned a value within the 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.