I have a cross tab report that I want to conditionally format text color if row# 5 meets my criteria. Below is the formula I am trying in the Format Field editor.
if {@Type} = "8=POH"
then crred
(I have also tried adding the else statement.....else crblack)
I get no results when I try this. I can change the text color via the formatting toolbar, but this changes all data in all 6-8 rows.
Is there another method to conditionally format the row, or is it just not possible?
Thanks
I just learned this yesterday, so here goes.
In the suppresion formula for the column total, enter the following expression:
numberVar x:=0; False;
This is going to reset the row count for each column
Then in the suppression formula for the summary field, enter the following expression:
numberVar x := x + 1; False;
And in the font color conditional formual, use the following expression:
numberVar X; if (X = 5) and ({@Type} = "8=POH") then crRed else crNoColor;
This should give you a red 5th row if the type condition is met
Fuskie
Who cautions that he does not know what the {@Type} formula contains and that it might need to be modified to be used in this context...
Add a comment