<div>
I KNOW BUT IN MY CROSS TAB REPORT , I HAVE &nbsp;SUM OF DEBIT IN A COLUMN <br />
I NEED FORMULA IF SUM CREDIT &lt;0 BUT I AM NOT ABLE TO DO IT
</div>


I KNOW BUT IN MY CROSS TAB REPORT , I HAVE  SUM OF DEBIT IN A COLUMN
I NEED FORMULA IF SUM CREDIT <0 BUT I AM NOT ABLE TO DO IT

<div>
Hi,<br />
Include all the information and supportive data when you create a question, so that the back and forth comments can be avoided.<br />
Clarify more or provide report with saved data for reference as we need to know the dynamic column number for referencing it to change the color of your required field.
</div>


Hi,
Include all the information and supportive data when you create a question, so that the back and forth comments can be avoided.
Clarify more or provide report with saved data for reference as we need to know the dynamic column number for referencing it to change the color of your required field.

<div>
Is the credit value in the cross tab?<br />
<br />
If so you can use the <br />
GridValueAt function to get the value and compare to 0<br />
<br />
mlmcc
</div>


Is the credit value in the cross tab?

If so you can use the
GridValueAt function to get the value and compare to 0

mlmcc

<div>
thank you four your useful help &nbsp;and solution
</div>


thank you four your useful help  and solution

<div>
<div class="content wysiwyg-content">
i have a cross tab report with 2 values ex LL -1.75<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; US 1.75<br />
<br />
i need to have the below result LL -1.75 IN RED<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;US &nbsp;1.75<br />
<br />
HOR TO DO THAT
</div>
</div>


i have a cross tab report with 2 values ex LL -1.75
                                                                      US 1.75

i need to have the below result LL -1.75 IN RED
                                                     US  1.75

HOR TO DO THAT

cross tab report

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.