How to iterate through cells in a cross tab report row
I am sucessfully using a cross tab report and using Cell0OnBeforePrint() to colour in cells in the cross tab depending upon the value inside each cell.
I now want to do something similar in another cross tab but this time colour a cell depeding upon some function of the other cells in that row.
(In reality I want to highlight outliers by highlighting those cells that are more than one standard deviation below the mean of that row).
I know there is a Row0OnBeforePrint() that I already use in the other cross tab, but..
1) How can I iterate though all the cells in that row in order to do my calculation based upon the row values.
2) How can I then identify which cell I need to colour, based upon the results of that calculation?
Howard
I now want to do something similar in another cross tab but this time colour a cell depeding upon some function of the other cells in that row.
(In reality I want to highlight outliers by highlighting those cells that are more than one standard deviation below the mean of that row).
I know there is a Row0OnBeforePrint() that I already use in the other cross tab, but..
1) How can I iterate though all the cells in that row in order to do my calculation based upon the row values.
2) How can I then identify which cell I need to colour, based upon the results of that calculation?
Howard