Conditional Formating by row

building reports crystal reports
1

I need to format a field based on the row title.

Is there a way to format the field with a $ or % or no symbol, based on the row title? The example below consists of two fields. The title field and the amount field. The amount field would have conditional formating based on the title field.

I know I can do colors but can I do symbols with conditional formating?

Example:
:?: IF row title is “Employee Contrib $” THEN append “$” to the amount field ELSE
:?: IF row title is “Employee Contrib%” THEN append “%” to the amount field ELSE
:?: IF row title is <>[Employee Contrib%, Employee Contrib $] THEN append “” to the amount field:

Row Title --------------JMFG-----------AEM------------PCI

Employee Contrib $----$50.00----$10.00---------$60.00
Employee Contrib% ----%10--------%.5---------- %30

kmonoh :us: (BOB member since 2008-08-15)

2

Not sure you can put that type of logic in a Conditional Formatting but you can put this into a formula.
So put your logic into a formula (FormattedAmount for example) and instead of using the Amount in your report you use your formula.

This will impact sorting as it might be required to format the number as a string.

KMB :uk: (BOB member since 2004-02-11)