>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?
Why not simply Set the
Print ConditionDoubleClick to edit the field!
Click on Print Condition.
Fill in:
codetype="Administrative"This will appear If and only If the condition statement is true!
^_~
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.