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.
- The Detail row was selected
- Right click the row - Row Visibility
- Show or Hide based on the expression - Press the fx button
- In the Expression dialog box enter the formula:
=IIF(Previous(Fields!Fieldname.Value) = Fields!Fieldname.Value, TRUE, FALSE)
- Press the OK button
- 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 |
