I have no idea how to approach the following:
I have a file with student records used in a sub-summary report. The sub-summary report uses the school's name for the break field.
Here is a sample:
ID 1; John Doe; school A
ID 2; John Doe; school A
ID 3; John Doe; school A
ID 4; John Doe; school A
ID 5; John Doe; school B;
The sub-summary will show John Doe, twice because he appears in School A and B.
School B is the most recent school he attends. I still need the sub-summary to calculate all records for John Doe but show the most recent school only.
Here is a sample for the desired sub-summary:
John Doe; Record count 5