Custom Report Writer Templates

Looking for some templates you can use in Custom Report Writer? You've come to the right place! You can also edit the templates below to add more columns or change the date ranges.

See this section at the bottom of the article on how to upload these templates.

 Even more templates!

We have created a Google Drive folder with frequently requested templates which you can access by clicking below!

google-drive.png

 

Our most commonly requested reports

Siblings Report Templates

To see a report of students and their siblings who are currently enrolled, use this Enrolled Siblings report template, or to see a list of students and all of their siblings use this All Siblings report template.

Screenshot_2020-06-22_at_14.50.06.png

 

Attendance for 1st September - 20th March Report Template

To see a report of individual student attendance from 1st September to 20th March, use this Report Template. This template also shows student UPN, name, DOB, postcode, transportation mode, year group, gender and ethnicity.

Screenshot_2020-06-22_at_12.57.19.png

 

Reg Forms and Reg Tutors Next Year Report Template

Once you've enrolled your applicants for next year into registration forms, you can let parents know what registration forms they will be in and their tutor by using Custom Report Writer data in a mail merge. To create the mail merge fields, use our Reg Forms and Reg Tutors Next Year Report Template.

Screen_Shot_2019-07-02_at_16.33.48.png

 

Mode of Travel Report Template

To see a report of student transportation details in your schools, use our Mode of Travel Report Template.  This template shows student UPN, name, DOB, postcode, transportation mode, year group, gender and ethnicity.

Screen_Shot_2020-02-11_at_11.11.49.png

 

Native Language Numbers Report Template

To see the native languages in your schools, use our Native Language Numbers Report Template.  This template shows all the languages logged as a native language for a student, the number of native languages at your school, the number of students who speak each language and the number of languages assigned.

Please note that if a student has not been given a language they won't be counted, but if a student has been given more than one native language they will be counted twice.

Screen_Shot_2019-09-24_at_08.21.05.png

 

Nursery/Reception Milk Numbers Report Template

To see the dates of birth of your reception and nursery students to see who is entitled to free milk, use our Nursery/Reception Milk Numbers Report Template.

Screen_Shot_2019-07-24_at_15.12.39.png

  

Weekly Attendance

If you run an attendance report of the past week on a Friday, grouped by Year, you can use our Weekly Attendance Report by Year Template.

Screen_Shot_2019-06-10_at_08.49.36.png

 

Termly 100% Attendance

If you run a termly report to find students with 100% attendance this term, you can use our Termly 100% Attendance Report Template.

Screen_Shot_2019-06-12_at_12.02.08.png

 

Low Annual Attendance

A persistently absent child is one who misses school 10% or more of the time. If you'd like to see a list of all your students who have had 10% or more percentage absences this year, you can use our Less than 90% Attendance Report Template.

Screen_Shot_2019-06-10_at_09.10.31.png

 

Dietary Requirements

If you want to run a report of all your current students with Dietary requirements, use our Dietary Requirements Report Template.

Screen_Shot_2019-06-10_at_09.19.03.png

 

All Guardians Contact Numbers

If you want to see all guardians emergency phone numbers in order of priority, use our All Guardians Emergency Contact Numbers Report Template.

Screen_Shot_2019-09-06_at_11.23.58.png

 

Detailed Primary Guardian Contact Details

If you want to see more Primary Guardian contact details than the report in Parents > Students & Guardians > Bulk Update > Guardian Contact Details shows, use our Primary Guardians Contact Details Report Template.

Screen_Shot_2019-06-10_at_09.30.44.png

 

Staff Leavers

If you want to see which staff members will be leaving your school this year (as long as they have had an end date entered), use our Staff Leavers This Year Report Template.

Screen_Shot_2019-06-21_at_12.47.05.png

  

How do I upload a template?

To download the template and save it to your computer, click the report link at the bottom of this article.

Go to School > Custom Report Writer. Click the Create New Report button.

Screen_Shot_2019-06-10_at_09.33.59.png

 

Select the button at the bottom of the page to Import a Report.

Screen_Shot_2019-06-10_at_09.34.41.png

 

Click Browse to select the template file from your computer, then click Upload.

Screen_Shot_2019-06-10_at_09.35.33.png

 

9 out of 10 found this helpful
I'm still stuck!

Comments

0 comments

Please sign in to leave a comment.