Zero Row Suppression

[sangland2]

Hi, Is it only possible to suppress a row in a table if all the expression values display as zero. A blank value in any expression won't achieve this. So I have text fields showing zero value that I then have to hide with conditional formatting. With a large number of expressions in a table this is tedious.  What if I want to suppress rows where a value in a particular field is a certain value (variable) not just zero ? Thanks

[Chanty4u]

u will hve a option Hide column

or chk dis

Suppress rows depending on the value of a particular expression

Re: Suppressing Rows

[Chanty4u]

chk dis

[sangland2]

Thanks, but I don't want to hide any columns.

[sangland2]

Thanks for the Aggr tip on that link. I can see that this would work. Problem is that my Dimensions are calculations, not just a field in a table. I'll play with this.

[psankepalli]

try this option from the below link, it may be helpful

Suppress Rows in Chart if Expression is zero?

[sangland2]

Thanks. I tried this option but there many expression fields to add this into. Some expressions are return text fields so forcing a zero in here is ugly. formatting can take care of this but still lots of expression fields. Functionality to suppress if zero is good but why only zero and not some other condition. Seems like basic functionality to conditionally suppress rows is missing in the GUI. Hopefully I can get the Aggr to work.