Skip to Content
0
Former Member
Jul 16, 2008 at 09:29 PM

Record Evaluation

23 Views

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