Crystal Reports for Eclipse Designer Guide

General purpose conditional formatting functions (Crystal syntax)

There are three general purpose conditional formatting functions:
  • CurrentFieldValue
  • DefaultAttribute
  • GridRowColumnValue
These functions are displayed at the top of the Functions tree whenever appropriate. DefaultAttribute can be used for any formatting formula, CurrentFieldValue for any formatting formula where you are formatting a field value, and GridRowColumnValue for any formatting formula where you are formatting a field value in a Cross-Tab.
In particular, CurrentFieldValue allows you to conditionally format the cells of a Cross-Tab based on their value while GridRowColumnValue lets you conditionally format the cells of a Cross-Tab based on the values of the row or column headings. These two functions are essential in this situation since there is no other way in the formula language to refer to the values of these fields. For example, if you wanted Cross-Tab cells to be suppressed if the values are less than 50,000:
//Conditional formatting example 4
CurrentFieldValue < 50000




SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/