Crystal V11. Trying to select only records for the last year for which there is data in each report group.
Example: Group A may have data for years 2001, 2002, & 2003. I only want the records from 2003.
Example: Group B may have data for years 2006 & 2007. I only want the records from 2007.
The year is recorded in a database field as a string with length of 2 ie "07"