I don't know if this is the right section to ask, in case of error, feel free to move/close the topic.

 

I have a problem using CR2008:

I am using a crosstab with various rows/cols, and I need to change the rows background-color depending of the value of one of these fields.

 

I'll show some of my entries:

 

row1: "aaa", "255, 255, 255", "somevalue"..

row2: "bbb", "120, 255, 255", "somevalue"..

row3: "ccc",  "240, 240, 255",  "somevalue"...

 

and so on...

 

 

I need to set the row1 color on color(255,255,255), row2 color on color(120, 255,255), but I'm still missing the point to do that.

 

I tried the following formula in the background formula editor :

 

 

stringvar x:= {"fieldName"};
stringvar s1 := Split (x, ",")[1];
stringvar s2 := Split (x, ",")[2];
stringvar s3 := Split (x, ",")[3];
numbervar n1 = Val(s1);
numbervar n2 = Val(s2);
numbervar n3 = Val(s3);
color(n1,n2,n3);

 

but It doesn't work.

 

Any help will be appreciated.

 

Thank you