Field Formatting

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Randal_(Guest)
Posts: 29
Joined: Tue Oct 10, 2017 12:44 pm

Field Formatting

Post by Randal_(Guest) » Thu May 20, 2004 5:50 am

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__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Field Formatting

Post by kfleming » Thu May 20, 2004 7:21 am

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__

Post Reply