[RESOLVED] how do i change field value 0 to Blank in crystal report 8.5?

[kaushal.jam]

hi all,

i am using crystal report 8.5 and vb6 for code and access for database.

now in my table some fields have its value " 0 " and those are numeric fields. now i dont want to display " 0 " in those fields when i create a report in crystal report 8.5.

can anyone help for that?

Please Help ASAP....thanks in advance...

kaushal

[jggtz]

Right click over each field (or you could multiselect fields)
A popup menu appear
Select "Format Field"
A "Format Editor" window appear
Select "Number" tab
Click "Customize" button
Check "Suppress If Zero"

[kaushal.jam]

THANKS A LOT JGGTZ. its nicely done...

Kaushal