Supressing a field based on value on a report

  • Rightclick the field and choose ‘Format’
  • Go to the tab ‘Common’
  • Tick ‘Supress’ and click on the formula editor
  • Enter the formula as shown below
if {yourtablename.yourfieldname} =0 then
    true
else
    false