Thanks Tim.
I tried that yesterday, but the report still came up with "Nothing to display".
However, some users were not in any of the course groups.
I set it to "All participants" AND "All users who have attempted the quiz", everything worked smoothly.
Problem solved. The system works fine, another case of human error!