You can 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!