admin管理员组

文章数量:1406033

I have a report in report builder which provides a list of thousands of rows and I want to highlight where an ID is duplicated.

I have tried Text Box Properties > Fill for example:

=IIf(Fields!Child_ID__System_Ref_.Value=Fields!Child_ID__System_Ref_.Value,""Red","Black") this doesn't work

I have tried =IIf(Previous(Fields!Child_ID__System_Ref_.Value,"Red","Black")) this doesn't work

The problem that I have is that the duplicate isn't a simple =IIF(Fields!FIELDNAME.Value = "VALUE", "Colour positive", "Colour Negative")

Can anyone offer any advice please. I have searched the web and cannot find anything :(

本文标签: