Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing color of text based on result

Status
Not open for further replies.
Jun 17, 2010
58
US
I am trying to color code results from a formula. The formula is a local formula and the results are calculated and vary on every record accessed in the Details section of the main report.

Is there a way to color code from within CR11r2 other than under the formatting formula section, like within the formula itself or set a variable that can be accessed by the formatting formula section for every record.
 
Can only be done in the font section under the field object properties in the x->2 selection. click on that icon and you can enter in the formula below if the results are greater than 5 and you want red. otherwise you can use the default. You can potentially use CurrentFieldValue as well.

If {@variablenameusedinformula} > 5.00 then crRed
Else defaultattribute;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top