Try this:
1. Sort on column 2 inside your group.
2. Put a suppression formual on the details section where the rest of your data displays. It will look something like this:
NextIsNull({table.group_name}) or {table.group_name} <> next({table.group_name})
This will keep the last record in the group from showing up in the details so that you can put it in the group footer.
-Dell
IP Logged
