Design SIMS Report for specific Attendance comparison

[CHiLL]

I have been asked to generate an urgent report to obtain the following data:

 

Compare attendance data for SEND students with codes E and K vs all non-SEND students for 2024-2025 academic year

Compare attendance data for SEND students with codes E and K vs all non-SEND students for 2025-2026 academic year

Compare fixed term suspensions for SEND E/K students vs all non-SEND students for 2024-2025 academic year

Compare fixed term suspensions for SEND E/K students vs all non-SEND students for 2025-2026 academic year

 

Of course this is last minutes and the data is needed for tomorrow afternoon (26/02/2026).

 

I have designed a report which I believe contains the data fields that are required, however, when I attempt to run it, throws some errors, shown in the attached screenshots. I have narrowed this down to the data fields "Attendance" and any of the sub-fields, where having them selected, will cause the attached errors.

 

I am not a report wizard and I'm stuck as to how to obtain the data that is being requested.