all groups > sql server reporting services > august 2006 >
You're in the

sql server reporting services

group:

Matrix Group Shading



Matrix Group Shading daveg.01 NO[at]SPAM gmail.com
8/7/2006 2:48:20 PM
sql server reporting services:
I am using SQL 2000 Reporting Services.

I am trying to get a column group to shade if it starts with the word
Total. The problem is there is not always a "Total" value for a
particular "row group" (date). Is there a way to shade the entire
column?

Here is the current formula. Is there a way to reference the current
group header?
=iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")

Thanks,
Re: Matrix Group Shading daveg.01 NO[at]SPAM gmail.com
8/9/2006 8:32:37 AM
Basically I want to set the background color on the entire column if
the group (column) header begins with the word "Total".


[quoted text, click to view]
AddThis Social Bookmark Button