Crystal Reports for Eclipse Designer Guide

Applying conditional formatting using parameter fields

Parameter fields can be used to create conditional formatting formulas. You can specify new values for these formulas whenever you refresh the report data. A conditional formatting formula could be used for color-flagging data that meets certain conditions. For example:
  • Sales representatives who sell more than 10% over quota.
  • Customers who have not ordered in the last quarter.
  • Inventory items that have not had any movement in the last month.
If the conditions under which you flag these items never change, you do not need to use parameter fields. You can just use formulas. However, to change the conditions, you need to use parameter fields in formulas and conditional formatting formulas.
For example, if you want the names of all the customers whose last year's sales were over a certain value to display in red, you might follow the steps in this procedure.



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