The detail line of my report shows data for a student with several events over a period. This is grouped by student.
In the footer, I am asked to total the number of types of student in 8 different tables (eg males/females, ethnicity etc) some of which are per type of school.
This is ok until some student is in two schools of different types during the period. Now the running totals count him twice, and the totals in any table don't match the rest of the report where the type of school isn't involved.
What they want is to only count him in the school type at the latest dated event in the period. Is there any way to do this using running totals?
Some of this data needs subreports to extract, I am already 'manually' summing the data from these because I cannot use sub-subreports or running totals here, so I do not want to have to create another couple of dozen formulae unless really necessary. There are nearly 200 already!
IP Logged
