hi, this is my 1st post so please excuse any mistakes i make. I have a crystal 10 report querying oracle 10g db. the report counts & details number of claims made for school meals, grouped by benefit type the guardian receives, then grouped by benefit office for each benefit type. There may be multiple benefit types against each guardian so i only want to count the most recent benefit type end date (which is normally a future date but may be a valid past date). Each guardian may claim for more than 1 child but each child should only appear on the report once.At the minute my report is showing a child's claim details under each benefit type the guardian has, not just under the most recent. Can anyone help please? many thanks.