Something like this? (You'd have to import the report into your project. It's using a connection to my dummy database, but you'd have to change it to point to your database.

The only confusing part is when you have to add the totals row... the rest was pretty easy.