Reading Records

[edwindow]

How do I an entire record based on a criteria that may be listed multiple times and then return a result. I have always seen crystal evaluate each record at a time. I would like to know if I can do some type of while loop that evlauated each record in one formula before returning a value to the report.

Example. I have a table that has many employee id's however they are listed multiple times. Now I am looking for one id that has an associated value; however I need to check the entire table before I can return a result to the report. What is happening now is that I am just getting all the emp id's that match because it is a unique identifier.

Please help.

 

[kken]

You must create a subreport to do the processing (looking for one id that has an associated value). Then link the employee id in the main report to the subreport. Then for every employee id the subreport will be run.