Sims lesson monitor - late report for period 1
I am trying to create a report using Sims.net to list all the pupils who were late for period 1 over a peirod of a week.
We have a day structured period 1,period 2, then registration, then period 3, period 4 and period 5. This means the pupils late to school are listed as late for period 1, rather than the AM/PM mark which is taken during registration.
I have created a report which lists all the pupils with late marks over a set time period (i'm using a week) and it will tell me the pupils with late marks (filtering) and which subject this was for, however I can't figure out how to add the period information to this, ideally I'd like to filter by period 1, however i can do this in Microsoft Excel after running the report.
Is there anyone who can help me either create the report in a different way to achieve the same result, or how to add this element to my report.