[SIMS] Attendance Report

[hslipper]

Hi,

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:

Focus: Student
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?

Thanks.

[RCowderoy]

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.

[vikpaw]

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.

[tombry]

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.

[vikpaw]

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