Complicated display in group footer
Ok this is kind of complicated but here goes:
I have a field called Data that contains numbers. In the group footer I wand a box that colors itself based on the number in the "Data" field from the detail section like so:
if Data then Box quadrant Colored
1 all of box
2 top right hand quadrant
3 top left hand quadrant
It goes on like this and the quadrants are divided as well. There is never an overlap i.e. you would never have both a 1 and a 2 in the same group, there may be multiple numbers in the detail and I want all numbers represented in the same box.
|