Making Reports with C#/MySQL

Question

Hello everyone,

I am currently working on an application in C# which requires me to create reports based on a MySQL database. I have been searching for quite some time, and the only way it seems possible is with crystal reports, which I have never used before. The application is quite complex and this is just the reporting aspect of it, I had anticipated that MySQL would have easily done this by using aggregate functions like Group By. Unfortunately it does not, and I am at a road block in my program. These are the kind of reports I would like to create:

Report


This report was done in access.

Does anyone have any suggestions on how I can make a report using C# and MySQL?
Any help is greatly appreciated, thank you.

Matt