[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