This is pretty much what I have done now. So, I am using the AM/PM built in report for the dates required, dumping to xml then have some VBA code in our spreadsheet to reverse the name order (to match the name order used by the Attendance Officer in her spreadsheet) and workout the overall attendance %, then I can run the VBA that I had written to do all the stuff that the attendance officer needs.
It appears to me that this is (possibly) needlessly complicated. The reason I got involved in this was our Attendance Officer couldn't work out how to get over attendance % for a given range out of Sims and into her spreadsheet. So some observations from this experience:
- Unless I have missed something (and as indicated in a previous post) there is no built in report that can give overall attendance % for a given range. It would be useful to either have an overall % at the end of the AM/PM report or have a separate report showing this.
- It would be even better if we could have access to the more than just current attendance % in the reporting dictionary; if we had access to historic marks then (I think) it wouldn't be that difficult to build a report that filters marks between certain dates.
The report probably runs a stored procedure which could be scheduled and possibly give the data in a more user friendly format. But that's a hack
One of the biggest problems I had was a lot of templates just went bang one day and disappeared, never got to the bottom of it. I haven't been able to recover them and subsequently stopped using macros and templates full stop. :(