Hi, folks.

I have a table of employees and a table of certifications. An employee may have 0-15 certifications (and dates completed).

I'm trying to generate a single line report like this:

NAME - CPR DATE - FIRST AID DATE - Etc

I've made an evaluation formula:

If {Cert_Table.Type} = "CPR" then {Cert_Table.Date}

This works brilliantly...as long as CPR is the first record that matches the employee ID. If it is the second, it leaves the field erroneously blank.

I know the ideal way to show this would be a list, but the boss wants a single-line representation of the key certification dates.

How do I get crystal to report back the CPR date regardless of which order it appears?

Thanks in advance!

Maximum formula worked like a charm.

Huge thanks!