Analyze Content of One Field across Found Set

[innodat]

Hi all,

I would like to set the title of a report based on a calculation which checks the contents of a particular field (Field A).

If the Field A contains only "Apple" values in the entire found set, I would like the title calculation to read "Apples".

If the Field A only contains "Orange" values in the entire found set, I would like the title to read "Oranges".

And finally, if there's both Apple and Orange values in the found set, the title should read "Apples and Oranges.

How could this be achieved? Any tips much appreciated!