During a recent Crystal Reports training session one of the delegates asked "What is the Advantage of using the CurrentFieldValue function.
The CurrentFieldValue() is a handy little function that allows one to format multiple fields at the same time, as it looks at the current field value, rather than the specific field itself.
So if one wanted to apply a conditional formatting formula to a number of fields simultaneously, one could select the required field objects, and create the following formula, via the format menu:
IF CURRENTFIELDVALUE > 1000
THEN CRLIME
ELSE CRRED
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us | 
