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?
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!