You can create a report displaying students' Destination Schools a few ways.
Previous Academic Years
If you are wanting to report on previous academic years, you would need to select the students current Year group (E.g. last years Year 6 will now be Year 7
1. Custom Report
by going to Reporting > Custom Report > New Report.
If required, select a year group (e.g. Year 6) in the General Filters area, and include Off Roll students if this is relevant.
Under Display Columns on the 'Misc Tab' tick Destination schools.
You may also wish to select Leaving Date on the Dates tab.
When you run the report it will display the students in that selected year, with a column for their Destination schools.
2. Admissions and Leavers Report
Alternatively you could run the Admissions and Leavers report via Reporting > Reports > Student (tab) > Admissions and Leavers.
Refer to - Admissions and Leavers Report
If required, select a year group and the date range for student departures, plus be sure to include Former Students if they are Off Roll
There will be a column for Destination School in this report.