I'm new to report making on SIMS and stuck with one stage of a report.
I would like to make a report that lists the UPN's of pupils with 100% attendance between two given dates. I am stuck when it comes to setting date parameters.
So far I have:
Fields: UPN, Forename and Surname, % Present
Filter: Present = 10%
The only date option I can find is the one at the end giving me the option to set an individual date?
If you run a lesson monitor report you can set the parameter such as date and % although you only get list of name and not UPN
Select Reports | Lesson Monitor | Selected Student Reports |
Percentage Attendance Report to display the Percentage Attendance browser.
If you're just using the basic section for attendance summary, that will default to the year.
You'd need to add the sub-table for attendance then filter that section for marks = '/' and mark date between x and y. If you add no fields from the sub-table it will do a count of them, and then you will have to know what 100% would equate to, i.e. 10 per week for 4 weeks, so you're looking for anyone with a 40 count.
It's not pretty.
one of the things I would love to see is to have some access to the pre-built lesson monitor reports to add in fields I'd like (or our attendance officer really) onto the reports.
too right. if you compose the CR, i'll +2 it ;)
Originally Posted by tombry