ASP & SQL Report

I'm new to ASP & wish to use it to create SQL report based on the following query:
SELECT DISTINCTROW Users.LastName, Users.FirstName, Users.JobTitle, Courses.CourseName, Status.Status, Status.Date FROM Users INNER JOIN (Courses INNER JOIN Status ON Courses.CourseID = Status.CourseID) ON Users.LoginName = Status.LoginName WHERE (((Status.Option)="Required")) ORDER BY Users.LastName;

Do I need to break up the SQL query per row and write out the report? I was thinking I could create this query, retrieve the information & create an SQL report.

However, my SQL is very rusty so I don't remember how to make the command (the only nice thing about GUI interfaces, the client thinks I know how to make the report as I can print it from the db.).