Suppress the duplicate values in group, SSRS Reports


I have an SSRS report
where the date should be grouped by project category
the project code in the category is repeating in side the group how do I suppress the value

Please help me to get an idea.


Best Answer

You can also hide fields by putting an expression in the Hidden property like this:

=Fields!ProductCode.Value = Previous(Fields!ProductCode.Value)

So if the value in the previous record is the same as this one, it will hide the field. You must sort the dataset correctly for this to work. In your case I think the sorting would be Date, ProductCategory, ProductCode.

In the past I used this often together with expressions for field borders to group the output visually.

Related Topic