Last post Jul 13, 2011 03:46 AM by You-Hu Fu
Jul 08, 2011 05:19 AM|jassu107|LINK
I have a matrix in which ROW part is grouped by Period .The Data part consist of Class,Teacher. The Column part is DATE
Now what I want is that when The Year changes the Data part colour should also change.
When the Period values changes the color of corresponding Data part should change from previous value
So Period 2 should have different colour , period 3 different and Period 4 different....
How is this possible
Jul 11, 2011 05:30 AM|Nishantg|LINK
I think this is possible only if you are using SQL 2008R2. In this version we have a lookup function using which you can achieve it.
1. You need to create a dataset where you have define the color for each of the possible groups.
2. Then you can write a expression in the background color of the row using Lookup function whcih will return you the color name based on the groupname.
But I am wondering if you can have a dataset which will having the probable group name and color, because might be in future the groups increased.
I hope it will help you.
Jul 13, 2011 03:46 AM|You-Hu Fu|LINK
You can refer to this link http://blogs.msdn.com/b/chrishays/archive/2004/08/30/greenbarmatrix.aspx which supply the steps to get the green-bar effect (alternating colors)
in a matrix