Is there a way to use conditional formating to change the value displayed in the report? I know I can change colors, fonts, etc... However I am curious if the actual field value can be changed.

If this was HTML, I would use Javascript, however I am using PDF as the output.

Please provide an example of what you want to do.


TYPE=DATA, COLUMN=CATTYPE,VALUE='Asset Retention' ,WHEN=CATTYPE EQ 'AR',$


Where the "VALUE" would be the TERM used to SET the FIELD to the value I want to display.

thanks

Try using a decode:

CATTYPE_DESC/Axx = DECODE CATTYPE(AR 'ASSET RETENTION'
ELSE 'OTHER)

Thank you, it was kind of a Duh moment!!!