CODEWITHSUNDEEP
reporting-servicesssrs-2008rowshiddenssrs-2008-r2
HazelPhillips
HazelPhillips

Reputation: 21

How to Sum Visible Rows Only SSRS

I am trying to sum only the visible rows only in SSRS and I have read a few forums that say you need to put:

=Sum( iif( <The condition of Visibility.Hidden expression>, 0, Fields!A.Value))

However I am unsure on how this works, my visibility code is:

 =iif(Fields!Sub.Value = "Ins", True, IIF(Fields!Sub.Value = "Ins - Int", True, False))

When I add this into the above 1st code i get #ERROR.

Appreciate any help.

Thanks

Upvotes: 1

Views: 1259

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

Try this:

=Sum(iif( 
Fields!Sub.Value = "Ins", 
0, 
IIF(Fields!Sub.Value = "Ins - Int", 0, Fields!A.Value)
))

Note I am not using the same expression for hiding the rows, I am just using its logic.

Hopefully this is what you are looking for, let me know if you need further help.

Upvotes: 1

Related Questions