Groups | Blog | Home
all groups > sql server reporting services > january 2006 >

sql server reporting services : Displaying duplicate row in red color



pmud
1/26/2006 11:21:01 AM
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
--
MattA
1/26/2006 1:48:13 PM
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
pmud
1/26/2006 2:50:02 PM
Thanks MattA. This is extremely helpful. :)
--
pmud


[quoted text, click to view]
William Stacey [MVP]
1/26/2006 6:02:27 PM
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]

[quoted text, click to view]
| 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
|

MattA
1/27/2006 5:53:46 AM
=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
William Stacey [MVP]
1/27/2006 9:45:25 AM
Thanks Matt. Are these processing "rules" layed out in BOL or somewhere.
Cheers!

--
William Stacey [MVP]

[quoted text, click to view]
| =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
|

AddThis Social Bookmark Button