Report for historic attendance figures
I am trying to write a report that will show pupil attendance figures on a certain date.
If I use the field '%Present + AEA' and enable supplying an effective data at runtime, it appears to always return the pupils' latest attendance figures no matter what date is supplied. If I put in any date from a previous academic year it appears to return their ending % figure.
I can't see any other field that would seem to do the job so does anyone know how to write this report?