Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-10-06 : 14:32:50
|
| On a related note regarding Colors, I would like to change the row color on rows that represent totals and sub-totals on matrix reports. Currently all normal data rows have a standard Transparent background color.Is there an expression I can use to determine if the row is a total/sub-total?John |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-10-06 : 15:11:45
|
| format for totals and sub-totals can be changed by right clicking on the small green triangle on top right of the field. also you can use the Inscope(<group name>) to determine if the row is total/sub-total. |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-06 : 15:21:38
|
| rohitkumar, thanks! Always wondered what the little triangle was for. WAY easier for me than inscope. I have been trying to find a good link to explain exactly what inscope does.John |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-10-06 : 15:26:01
|
| check thishttp://sqlblogcasts.com/blogs/jorg/archive/2007/12/06/SSRS-_2D00_-Custom-expressions-for-subtotals-in-a-matrix.aspx |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-06 : 15:40:41
|
| Thank you. I wanted to change the total for the entire matrix (Matrix1 for me) to have background of Gray. I clicked the data field and in properties for background color I typed =Iif(InScope("Matrix1"),"Gray","Transparent")And the total line has not changed.I also have 3 groupings, Matrix1_Club_Area, Matrix1_Catagory (yes I know it is mis-spelled) and finally Matrix_Sub_Type. I changed the InScope line to be:=Iif(InScope("Matrix1_Club_Area"),"Gray","Transparent")=Iif(InScope("Matrix1_Catagory"),"Gray","Transparent")=Iif(InScope("Matrix1_Sub_Type"),"Gray","Transparent")and I still have no changes.John |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-07 : 12:32:04
|
| I just found out that the row groups are VERY case sensative... By changing the word Matrix1 to lowercase, it is working. I am (almost) understanding the Totals effect now...John |
|
|
|
|
|
|
|
|
Change Background Color on Matrix Total rows