How to highlight duplicate records from different groups in SSRS report?

(0) Share

Report

Posted on by Community Member

Hello All,

I have requirement of highlighting duplicate records which are listing according to different columns in the report.

6087.REPORT-1.JPG

From the picture above, I want to highlight all the duplicate records under column C with respect to Column A. I tried all the functions to highlight those duplicate but was not able to highlight those duplicate records which comes under different columns.

Any ideas would be appreciated.

Thanks,

Sunny

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Mick_4711 552 on at

Like (0)

Report

Hi

have you tried the previous-function`?

=IIF(Previous(Fields!Fieldxxx.Value) = Fields!Fieldxxxx.Value, "Red", Nothing)

(The operator could maybe LIKE)

Best regards

Mick

Was this reply helpful? Yes No