Paul, thank you so much for your prompt response, this could be really helpful. If you could share the process that would be much appreacited and we would give feedback on the process.
Please advise if you need server access to run your report, or is it a job that you could access as if accessing a lesson?
The resulting spreadsheet will give us a way oa massaging that data as the back end reprting as you know is non existant, this is a downfall of Moodle in a corporate setting.
Cheers Sue