Hi alexander,

Unfortunately there is no way of doing what you describe. I've searched high and low, to to no effect.

Maybe you can have to cross tabs on top of eachother, one doing the backgroupd colour and one the actual value. I have not tried that one though.

Walter,




>Hi All!
>
>Can somebody help me in the following problem. I need to change background color of the summarized field in a crosstab depending on value of another field, which is not a row/column group field. But in Change highlighting option I can specify only value of this field or one of group fields. The same problem is in entering the formula for background color. I can get CurrentFieldValue() and GridRowColumnValue() only. I'd be satisfied by adding the another summarized field (with background highlighting) under the first field, but CR designer doesn't allow this.
>In fact I need to distinguish somehow cells with no data from the cells, which cannot contain data. Any other ideas to reach this goal are also welcomed.
>The environment is CR9 with VS2003.
>
>Thanks,
>Alexander