Suppressing zeros in ReportStudio

[coggie01]

I am working in Report Studio and am trying to suppress rows when all measures are zero in the report. Does anyone know how to go about doing this?

thanks!

 

[MissReportNet]

Hi,

You have to use an if then else statement.

Like:

IF([blabla] is 0) then (null)else ([bla2bla2])

Hope this will help you to get on the right track.

Cheers,

MissReportNet

 

[coggie01]

Thanks for your input though I will still have the problem of the record showing up but all with null values.

I would like to see happen if the all measures displayed in the report are zero then suppress the record from being displayed at all.

Thanks.

 

[KingCrab]

Conditional format

condition boolean: total(calc for report)=0