There are two options you have a report already created in Class which you may wish to try first this is the “Visa/Passport & UK Sponsorship”.

Otherwise you could create your own report within an Enrolment General Quick Report.

There is a helpsheet (no.SQL204 or SQL176) which covers this.  Please click on the following links to view or download helpsheet – HS204 Reporting – Student Visas Passports & UK Sponsorship Report.doc  or SQL176.net Visa Expiry Report.doc