Search code examples
ssrs-2008

Hide duplicate row SSRS 2008 R2

Duplicated data is coming in my report because source table has duplicate data. Without creating group, I want to hide duplicate data writing expression. So what I did: I select table row and put a expression for hidden property of table row.

The expression was like =(Previous(Fields!ID.Value) = Fields!ID.Value) but it did not work ... Still duplicate data is showing. So tell me how to suppress duplicate rows in ssrs writing expression not by grouping.

Solution

  • You probably should try these options first:

    • Try to clean the duplicate data at the source.
    • Change your source query so the duplicates don't appear in the dataset. (e.g. SELECT DISTINCT)

    If not, on the row's Visibility Hidden property you can use the Previous function:

    =iif(Fields!YourField.Value = Previous(Fields!YourField.Value), True, False)

    You would have to sort on the YourField column for it to work.