Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Complaining is silly. Either act or forget
Stefan Sagmeister
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


Why is Hide Duplicates in SQL Server Reporting Services Not Working?

A client contacted me regarding and issues she was having with a SQL server reporting services report, that contained duplicate records.

The client had used the setting HideDuplicates to deal with duplicate records, but this produced extra blank lines in the report.

They had tried a number of methods to try to resolve this issue.


Instead of using the SSRS HideDuplicate option, as more effective method was to use an expression to control the visibility of the row.

  1. The Detail row was selected
  2. Right click the row - Row Visibility
  3. Show or Hide based on the expression - Press the fx button
  4. In the Expression dialog box enter the formula:

    =IIF(Previous(Fields!Fieldname.Value) = Fields!Fieldname.Value, TRUE, FALSE)

  5. Press the OK button
  6. Press the OK button

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

35 + 50 =