Making a row not to be shown in Tablix based on a Real field value = 0.00

(0) Share

Report

Posted on by Community Member

Hi All,

I am trying to make a complete row not shown in my tablix of my SSRS report based on a Real field value when it is 0.00.

I have a Tablix with many fields, there is an amount field which is real type, and has decimal place up to 2, so when I run the report some records have amount field value = 0.00 , so I am trying to make the rows that has this value 0.00 in Amount not included in my report.

I tried setting expressions on Row group property's Visibility --> "Show or Hide based on expression" with below expression

=IIF(Fields!Variance.Value = 0.00,True,False)

But does not help.

Tried the same on row visibility, Tablix visibility but doesn't help.

Is there something I am missing?

Thoughts on this will be very helpful.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Sabarish K,

Maybe Variance has more than 2 decimal paces ? Did you try to round it, something like this:

=IIF(Round(Fields!Variance.Value, 2) = 0.00, True, False)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Awesome Ievgen, It works like a charm... Thanks a lot.. Was really helpful.

Was this reply helpful? Yes No