SETSUPPRESSZEROS

SETSUPPRESSZERO can be used to show or hide zero values in reports.

Syntax

SETSUPPRESSZEROS(VALUE)

Arguments

VALUE - Pass a boolean value of TRUE or FALSE.

Example

SETSUPPRESSZEROS(TRUE) //Suppresses zeroes
SETSUPPRESSZEROS(FALSE) //Displays zeroes

Set suppress zeroes

Notice how the Depreciation row that only contains zeroes is suppressed when the SuppressZeroes button is clicked and displayed again when the DisplayZeroes button is clicked. The buttons use the SETSUPPRESSZERO script internally to hide and display zero values.

Suppress zeroes script in action