Multiply Actions for an If statement

[spining123]

I have an If statement that I need about three actions for this statement if not null.

If the FormofMaterial is not null I would like to printout:
crred (to print in red)
"/" (just adding a / before the item)
FormofMaterial (the item)



Listed is what I have so far. Only printing out FormofMaterial or blank if null.

If not IsNull ({tblManuscriptCollections.FormofMaterial})
then {tblManuscriptCollections.FormofMaterial}
else " ";

Your help is truly appreciated

 

[dgillz]

This will take 2 formulas, one to get the output and one for conditional formatting. The first is a formula field:

If not IsNull ({tblManuscriptCollections.FormofMaterial})
then "/"&{tblManuscriptCollections.FormofMaterial}
else " "

the second is to get the red text. Right click the formula field above and select format. Then go to the font tab and click the X-2 button to the right of the color drop down box for conditional formatting, and enter the formula:

If not IsNull ({tblManuscriptCollections.FormofMaterial})
then red else defaultattribute.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[spining123]

Thank you very much dgilly. This solved the problem. Great Help.