none
Hiding duplicates does not hide them from totals!!! RRS feed

  • Question

  • VS 2010/VB.NET/ReportViewer

    Hi, I hope I will get help in here as this is driving me crazy!

    I use the following in the Visibility section to hide duplicates:

    =Previous(Fields!XYZ.Value) = Fields!XYZ.Value

    It works fine. But at the end of the report I have this cell:

    =sum(Fields!XYZ.Value)

    But it gives me the sum of all values (including the hidden ones)!

    How to get the sum of the visible values only?!!!

    Tuesday, January 7, 2014 3:36 PM