Goal:
I would like my report to evaluate a field for each record in the report. For example the field I want to evaluate contains two values, either YES or NO. At the bottom of the report I would like to have a Corrective Action unsurpressed based on a criteria I set. (note: This question is not about how to surppress a field etc, I have figured that out already).
End Result:
The end result I would like to see, is the report evaluating each record for YES or NO. However if there is ONE or more NO's then I want it to populate the corrective action at the bottom of the report.
Question:
How do I get crystal reports to evaluate each record on the report and if any one record has a NO then do X. (X being whatever I want it to be, and in this case to surppress or surppres a field).
Current Behavior:
Currently the report seems to only evaluate the last record. So if the last record is a NO then it un-surppresses the field corrective action and if its a YES then it surppresses the field corrective action. I want it to evaluate for any NO in the report not just the last record.
Thank You for your Time and Effort
Roy Payne