Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't make the same mistake twice
 
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!!!!

18
June

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.


Solution:

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
1

Darkimoo

25
January
Great! But I have a question. I have "Quantity" field. Does hiding the duplicate changes the SUM of the field?
2

Julia

29
January
Using the hiding the duplicated does not change the SUM of the Quantity field. You would have to create a manual running total for that

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

73 + 23 =