I have a report that has a field that is a currency sum printed in a GROUP footer. Based on info in another field, sometimes this field is blank and the customer would prefer it to NOT be there instead of $0.00.

I was able to add a IIF to the expression for the field as follows...

IIF(codetype="Administrative",emp.time,"")

emp.time is the amount field. The properties are set for SUM and currency for the format. When this field comes to print - if the codetype="Administrative", I get the appropriate summed amount... if it is not "Administrative", I get ******. I tired changing the "" to null, 0, and also setting the IF BLANK REMOVE LINE to yes. None of these seem to work.

Suggestions?