SSRS 2012 - Hide Duplicate Rows

1.8k views Asked by At

I have tried these 2 methods separately ,

  1. Row Visibility

    =IIf(Previous(Fields!name.Value) = Fields!name.Value, True, False)

For Above , do i need to add every field?

  1. HideDuplicates in Row Properties, that works, but it leaves behind blank rows.

My 2 Questions.

For 1., do i need to add every field?

For 2.,Im lost on how to remove the blank rows?

Thanks,

2

There are 2 answers

0
AndroidAL On BEST ANSWER

****************SOLVED******

To Solve this i used Group Properties. Group Properties> General> Group Expression> Group On: [createon]

1
Mike On

Add a Filter on the table properties so that blank rows are not in the data set.