Cell Background Color Not Filling in Column Group Correctly
-
Hello,
I have my rows set to change background color based on whether the event is a fixed site or mobile event. And it is behaving like I expect, changing the background fill color based on fixed site and mobile drives.
But my issue is that I also have a column grouping that is messing with my background fill colors. Ideally, I'd like to have the entire row filled with the same color, but currently only the cell in which a value appears is back filled correctly - leaving the other cells white/transparent.
Here is my original formula to toggle the background colors:
And here is where I am trying to set the column grouping background colors:
And what the results actually look like:
The "LightBlueSteel" color represents fixed site events and as you can see, if it doesn't have an value (incentive) assigned to the column grouping, it doesn't fill in the background color. And in the next to last row, the event has a incentive of a Sam's Club gift card and back fills that cell, but not the rest of the row.
How can I get the entire row to have the background color filled in in events like this?
Thanks,
-
You need to apply an expression to the Row Group background colour.
=Iif(
RunningValue(
Iif( Fields!OwnerType.Value = "Fixed", 1, 0 )
, Sum
, "Row_Group_Name"
) = 0
,"White"
,"LightSteelBlue"
)
Basically, this is applying a value of 1 to any data row that has an OwnerType of "Fixed", then performing a Sum of those 1s and 0s within the scope of "Row_Group_Name" and comparing the result - if it is zero, then you have no matching items on this row and can colour the background White, otherwise you must have a match somewhere on the row and can colour the row blue.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);- Forum Etiquette: How to post Reporting Services problems
[/url]- Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]- How to Post Performance Problems - by Gail Shaw
[/url] -
Thanks mr. magoo,
It does look better with this solution, but there is still one issue happening. If the incentive doesn't appear in the first column, the cell background colors are not filled. Is there a way to remedy this?
From the screenshot below, you can see the background color does not fill in until it reaches the incentive assigned to the drive. Suggestion to remedy this?
-
Oh yes, that makes sense because we are using the running value... No ideas right now but will think about it...
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);- Forum Etiquette: How to post Reporting Services problems
[/url]- Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]- How to Post Performance Problems - by Gail Shaw
[/url] -
To get the whole row to colour:
=Iif(
Max(
Iif( Fields!OwnerType.Value = "Fixed", 1, 0 )
, "Row_Group_Name"
) = 0
,"White"
,"LightSteelBlue"
)
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);- Forum Etiquette: How to post Reporting Services problems
[/url]- Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]- How to Post Performance Problems - by Gail Shaw
[/url] -
That worked beautifully. Thank you very much!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply