Background Color Conditional

[Chris Hays [MSFT]]

Yes, you can do that. Use something like the following expression for your
background color:

=iif(RowNumber("table1_Group1")<=ReportItems!GroupHeaderTextbox1.Value,"Gree
n","White")

--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."

"Blake Gremillion" <bgrem...@he-equipment.com> wrote in message
news:4803A3B7-874C-4207...@microsoft.com...
> I have a group header that contains a sum field and I want to highlight
the Top N rows in the detail section based on that value (e.g. If sum=4 then
first 4 detail rows are highlighted). Is this possible? I can't even figure
out how to use an expression for the background color property.

[Chris Hays [MSFT]]

Unless you're using filters or visibility or trying to do this in a matrix,
I'm stumped.
Perhaps you could post your RDL and I can take a look to see if anything
leaps out at me.

--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."

"Blake Gremillion" <bgrem...@he-equipment.com> wrote in message

news:CF5439AE-97C5-47E2...@microsoft.com...
> Ok, that works great. Now I have another related problem. The row
numbers in the detail section are not always sequential. Like sometimes row
3 is skipped (i.e. 1,2,4,5...) and the highlighting function doesn't work
here b/c I'm trying to highlight the first 3 rows in the detail. I thought
it might be b/c of my filters or visibility statements but I've taken them
out to no avail. Any ideas here?