Post reply

Highlighting duplicates in a report - using previous and highlighting with colour

  • February 25, 2015 at 5:01 am

    #398074

    Hello

    I am using =IIf(Previous(Fields!Col1.Value) = Fields!Col1.Value, Nothing, Fields!Col1.Value) in an SSRS report, which works fine, but instead of nothing, I would like the textbox to appear as red to highlight duplicate records.

    Any suggestions to achieve this would be very welcome.

    Thanks.

  • February 25, 2015 at 9:46 pm

    #1780112

    You could set the Fill color of a cell using something like this:

    =IIF(Previous(Fields!Company.Value)=Fields!Company.Value,"Red","Transparent")

  • February 25, 2015 at 11:36 pm

    #1780118

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply