Expression to hide the row in the SSRS report when value is 0

Finance and Operations/AX Technical Forum
1

Hi to All,

I want to hide the entire row of a table when the value is null .Is there any expression to hide the row, so there will be no white space is visible on the report.Please help

2

Hi,

Try this…

write the below expression in row visibilty expressions.(Check whether you are writing the expression for visible or hidden.)

=IIF(Fields!SlaesAmount.Value= 0,“Yes”,“No”)

3

thanks for the help [:D]