Displaying duplicate row in red color

Hi,
In my report, I have used a table. In the table, I want to display all the
duplicate rows in red color, i.e if Field1 is listed twice in the table
details, then I want to display the duplicate row in red color.
ANy ideas on how to achieve this?
Thanks
--
pmudSet the Color property of the textbox of Field1 to use an expression,
like this:
=IIF( Fields!Field1.Value = Previous( Fields!Field1.Value), "Red",
"Black")
Matt A|||Thanks MattA. This is extremely helpful. :)
--
pmud
"MattA" wrote:
> Set the Color property of the textbox of Field1 to use an expression,
> like this:
> =IIF( Fields!Field1.Value = Previous( Fields!Field1.Value), "Red",
> "Black")
> Matt A
>|||I was wondering if you can refer to the textbox.value from within a property
like:
=iif(textbox98.value > 0, "green", "red")
--
William Stacey [MVP]
"MattA" <mattarabas@.gmail.com> wrote in message
news:1138312093.490398.115610@.g14g2000cwa.googlegroups.com...
| Set the Color property of the textbox of Field1 to use an expression,
| like this:
|
| =IIF( Fields!Field1.Value = Previous( Fields!Field1.Value), "Red",
| "Black")
|
| Matt A
||||=IIF(ReportItems!textbox98.Value > 0, "GREEN", "RED")
Note that scope rules apply to ReportItems collection, so you'll have
scope limitations on being able to use it (not on aggregates, for
example...)
Matt A|||Thanks Matt. Are these processing "rules" layed out in BOL or somewhere.
Cheers!
--
William Stacey [MVP]
"MattA" <mattarabas@.gmail.com> wrote in message
news:1138370026.412815.53510@.g44g2000cwa.googlegroups.com...
| =IIF(ReportItems!textbox98.Value > 0, "GREEN", "RED")
|
| Note that scope rules apply to ReportItems collection, so you'll have
| scope limitations on being able to use it (not on aggregates, for
| example...)
|
| Matt A
|