w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
highlight the duplicate row values with background color in ssrs report

Say I have some simple data like this:

enter image
description here

If I'm setting up highlighting based on ID, I would make sure this is a group based on this column, e.g.

enter image
description here

Then, for the BackgroundColor property I would use an expression like:

=Switch(Count(Fields!ID.Value, "IDGroup") = 3, "Red"
    , Count(Fields!ID.Value, "IDGroup") = 2, "Green")

So for each detail row, count the ID values in the ID group and set the colour accordingly. Works for my data:

enter image
description here





© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.