Hiding lines with zeros?

[ARustad1645]

I'm writing a financial report and I'm wondering if there is a way to hide lines that are all zeros.

Thanks!

 

[Thingking]

Try the following:

if
(ParamDisplayValue("Filter???") = 0 )
then
('')
else
(ParamDisplayValue("Filter")

 

[ARustad1645]

Is there a way to do this for all lines, rather than having to do it for each data item? Also, my report is structured in such a way that each line (account) has actual numbers and budget numbers for the period selected). If both the actual and the budget are zero it want that line to be hidden. Any suggestions? Thanks for the help!!

 

[jem122974]

By using conditional formatting and the box type property for the list body.

First setup a boolean variable that checks if all the fiels are zero.

Then select the lists column body style using the ancestor button. There assign the style variable to the variable you created.

Finally in the condition explorer select the yes value (all fields are zero) of the variable and set the box type property to none.

That will hide rows where everything is zero in that row.