there is ad-hock report plugin ,you can download it from here
and configurable report plugin
here is link for different reports you can use.
see this report which do almost what you need
=========
SELECT
user2.firstname AS Firstname,
user2.lastname AS Lastname,
user2.email AS Email,
user2.city AS City,
course.fullname AS Course
FROM prefix_course AS course
JOIN prefix_enrol AS en ON en.courseid = course.id
JOIN prefix_user_enrolments AS ue ON ue.enrolid = en.id
JOIN prefix_user AS user2 ON ue.userid = user2.id
Where course.shortname='YourCourseShortName'
=================