You have to render the report first and then attach the output to the email message content. You can take a look at the notification-email module. If you want, tomorrow I can take a look at some of my modules. With this module my client sends an email with the report attached as a PDF.