Page 1 of 1

Field Formatting

Posted: Thu May 20, 2004 5:50 am
by Randal_(Guest)
I have a numeric field from a .dbf in the record band of a report but it will not print zeroes. The properties indicate "Show Zero". I^ve tried different fonts, field sizes, etc. If the field has a value other than 0 it prints fine. What could I be doing wrong? I have the same problem with 6.5 xbase, 8.1, and 10.0____Thanks,__Randal Ferguson__

=> RE: Field Formatting

Posted: Thu May 20, 2004 7:21 am
by kfleming
It could be that the field is null rather than zero.__One way around this would be a calculation with expression:__IIF(fieldname=0,0,fieldname)__This will allow nulls to display as zeros.____Kathleen__R&R Support__