The reason it was not working is because your evaluation was looking at one row. Since you placed the criteria in the footer it was looking at the last row. Your condition needed to evaluate all rows and that was what FrnhtGLI was suggesting by using a formula to make a summable amount to detemine your suppression need. THis is a good trick to use. In this case since you only have 2 values you could also use a MAXIMUM () option.
When you say the bottom of the report I assume you mean in the report footer and not a group footer. This is evalauting for the report footer. If you need to evalaute at a group level it can be altered to accomidate that ...
In the section expert or the field you can suppress using the formula:
MAXIMUM({Command.IS_HIGH_RISK})="Y"
Edited by DBlank - 21 Apr 2010 at 3:56am
IP Logged
