SSRS - Hide Duplicate Rows

Question

I've tried SSRS HideDuplicates and an approach which compares a data field with the previous row's value. Either one leaves me with empty rows, where the duplicates would have been.

How do I remove duplicate rows and prevent empty rows?

Changing the existing stored procedure to SELECT DISTINCT or creating a new stored procedure is not an option.

Answer 1

Hi @Brett Ossman ,
Please try to set the "Visibility" property by using the following expression:

=IIF(fields!fieldname.Value=Previous(Fields!fieldname.value),True,False)  

If the expression is based on Row Group Properties, whitespace caused by hiding duplicate rows will be removed.

See the following sample below about the "Row Growps" properties.

1) Right button on the Row Groups.

2) Click in Visibility

3) Click in Expression and type the following code: =IIF(fields!fieldname.Value=Previous(Fields!fieldname.value),True,False)

For more inforamtion, please see: SSRS Reports Hide Duplicate Records and White Spaces.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Brett Ossman

You can try another method , by group on the Details row .

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.