Crosstabs and GridRowColumnValue

[-cush-]

I am setting the backgound color of column headers like the following:

Select left(GridRowColumnValue("@StateReporting"),1)
Case "1": color(50,230,50)
Case "2": crAqua
Case "3": color(255,150,150)

That part works great. Next I pasted the same formula with the subtotals so the entire column matches the header. That also works. The problem is that there is a cell between the two with the word "Total" I would also like to be the same color, but when I past the formula in there I get the error, "This is not the name of a grid group for the field being formatted." See attachment.

 

[LaurieHamlin]

Can you copy and paste the design view of the report?

 

[-cush-]

Again, it works fine to set the background color based on GridRowColumnValue if you are setting it from either the Column Header or the subtotal field. But the header that just says "Total" cannot reference the GridRowColumnValue of the column name it is under.

 

[-cush-]

Ultimately I ended up exporting it to a spreadsheet to get the desired effect: