Hi @Michael_Tidd1, hope you've had a nice summer!
This may not be as long haul as you think. We have a new report in the works (currently in testing but basically done). It's a pretty powerful report, designed to let you build the pro-formas you need to generate each term. Below I've included a few examples of what it'll let you do.
Comparing attainment from 2016-17 summer against 2017-18 summer, for Reading, Writing, Maths years 1-6:
Comparing the summer teacher assessment against the NFER scores (apologies that my demo is lacking in data!). This is for Reading, Year 6, grouped by Key Groups:
We're still figuring out the best ways to make this report user-friendly, as it's... slightly intense! But if you'd like to be an early tester, just email me at firstname.lastname@example.org and I can send you a link to have a play around with it with your own data.