SSRS 2005 Background color of a matrix value taken from another field

SSRS 2005 Background color of a matrix value taken from another field

Ok, so here a sample of a dataset I’m try to report on a matrix.  The Code field represents the row, MonthYear the column and the value is the detail data.  Now I want to apply the colour to the background of the data cells.

So in the backgroundColor property of the value textbox, I put in 

=First(Fields!Colour.Value, "datasetname")

Can anyone please tell me what I am doing wrong? I believe this would work in the 2008 versions.

First thing to check is that your tablix is associated with your data set this can be done by going to the tablix's properties and verifying the Data set Name field which should be your data set.

If this is verified then what you need to do is to edit the background expression of the "Value" textbox which will be exactly this =Fields!Colour.Value.

Last but not least you probably want to ensure that the actual values of the Colour column are valid color names, if not you will generate an error.

 

Copyright © 2007-2012 www.chuibin.com Chuibin Copyright