Alternate row color for matrix where i have Row group and colum group
Hi, I am using matrix in my report which is having one Row Group called ROW_GROUP and one colum group called COLUMN_GROUP. i need to give alternate color for row. I am using this expression "IIf(RUNNINGVALUE(Fields!ROW_GROUP_COLUMN.Value,CountDistinct,Nothing) MOD 2, "White","#f6fb72")" but it is not working out. please anyone can help me on this issue.Thanks Shiven:)
April 22nd, 2010 9:47am

You can try taking a look at the following article. http://www.wrox.com/WileyCDA/Section/Report-Solution-Patterns-and-Recipes-Greenbar-Reports.id-291857.html Regards Neerav
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2010 10:19am

Also you can take a look at the following http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/3cdcd636-27ce-4153-b46c-f9f94d51efa2
April 22nd, 2010 10:20am

I can't go for this.Thanks Shiven:)
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2010 10:40am

This i have already checked. Not usefulThanks Shiven:)
April 22nd, 2010 10:41am

Hi S Kumar Dubey, Your issue is obviously cased by the Scope of the RunningValue function,we can achieve this in Sql Server Reporting Service 2008 using your expression.But in Sql Server Reporting Service 2005,we should select every textbox to set its background color with the right Scope rather than the whole row.See this picture: 1. Click the Red circle and press 'F4',Property window will be displayed in your right side 2. Find out the BackgroundColor property,and then type in the expression =IIF(Runningvalue(Fields!Category.Value,CountDistinct,"matrix1") mod 2,"Red","Lime"). Note:matrix1 is the name of your matrix 3. Click the green circle and press 'F4',type in the expression in the backgroundcolor property =IIF(Runningvalue(Fields!Category.Value,CountDistinct,"matrix1_Year") mod 2,"Red","Lime") Note:matrix1_Year is the name of the column group. Below picture is produced by the above steps, you can set your color depending on requirement. If you have any question,please feel free to ask. Thanks, Challen Foo
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2010 9:02am

Hi All, My problem got resolved. I used below Method: I created a dummy column out of Column group. There in all Text box for dummy column, i gave this alternate color expression "IIf(RUNNINGVALUE(Fields!ROW_GROUP_COLUMN.Value,CountDistinct,Nothing) MOD 2, "White","#f6fb72")" and in Column Groups i used this expression =ReportItems!TXT_Color.Value. It is working perfectly. Please don't forget to hide dummy column.Thanks Shiven:)
May 4th, 2010 1:03pm

Hi Challen Foo, your method is not working for me.Thanks Shiven:)
Free Windows Admin Tool Kit Click here and download it now
May 4th, 2010 2:23pm

Hi S Kumar Dubey, I am glad to hear that you solved the issue by yourself, no matter whose method,solving the problem is the top priority.Welcome to pose the case in this forum when you have questions, we are happy to discuss together. Regards, Challen Foo
May 5th, 2010 4:27am

Hi, We can use any of below expressions for Alternate row coloring =Iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White") OR =Iif(RowNumber("Employees") Mod 2, "PaleGreen", "White") Where Employees is dataset Name OR "IIf(RUNNINGVALUE(Fields!ROW_GROUP_COLUMN.Value,CountDistinct,Nothing) MOD 2, "White","#f6fb72")" Thanks Shiven:)
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2010 2:43am

My problem got solved from above answer.Thanks Challen Fu.
December 3rd, 2010 8:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics