Creating a report of students' locations for each class

You can now produce a report in the Custom Report Writer that shows the location of every student in each period, for the whole day. And it takes just 5 minutes, with no downloads, v-lookups or manual messing about with data!

We've designed these Custom Report Writer fields based on feedback from our schools that they need to produce a list of year 9, including where they are for periods 1, 2 and 3 to take them out of lessons for their immunisation jabs. This is the example we'll use in this article, but you can use these new fields to report any way you wish!

Please note: For this report to work, you will need to have set up periods on your site. Take a look at this article on Creating Timetable Periods for how to do this.


Example - creating an immunisations report

Just go to School > Custom Report Writer and click the Create New Report buttons to get started!

First, add your report name and specify that the report is about students.

Next, select the date range of your report. In my example, I'm choosing a specific date but you could also set this to 'today'. 



In step 3, search for the word 'timetable' in the search box and click and drag the Timetabled event field over to the right-hand side.



In the slide over, select period 1, then click Save.



Next, drag the Timetabled location field over to the right-hand side. In the slide over, select period 1, then click Save



You'll then need to repeat this for the other periods you would also like to show, for example, period 2 and 3 as well.

We then recommend clicking the Skip setup wizard link at the bottom of the page. This will take you to your report editing overview.



In the Filters section, type in NC year 9, select it, then click Add Filter.



In the slide over, click Save without changing the details.



Next, add another filter for Gender, and in the slide over select Female.



Finally, click the Save and View Report button to see your report.



Top Tip: Want to sort students by the class they're in so all students in the same class are grouped together? Just click the column header!



Was this article helpful?
0 out of 1 found this helpful
I'm still stuck!



Please sign in to leave a comment.