Page 1 of 1

Zeros Not Showing - Sometimes....

Posted: Fri Apr 29, 2005 6:07 am
by Mike_Wilcock_(Guest)
Hi,____We use R&R 11 with Xbase++ and seem to have discovered a slight anomaly. Sometimes on our reports zeros do not display even though the show zero flag is ticked. This particularly seems to be affecting our carriage field which is a numeric field.____Oddly though if you actually replace data into the field, for example...____Replace POPHEAD->CARR_NET With 0.00____The zero will then show on the report.____Anyone have any ideas?______Mike

=> Zeros Not Showing - Sometimes....

Posted: Fri Apr 29, 2005 6:55 am
by kfleming
The data field may be empty rather than containing an actual zero value and that is why R&R displays an empty value rather than a zero. But if you do a calculation that says:____IIF(datafield=0,0,datafield)____you will convert the nulls to zeros.____Kathleen__R&R Support