While creating an automation policy to send email with an report and following settings:
Edit input parameter and selecting "Report URL" and "Report as CSV" does not send an email with CSV file attached.
7.x / 8.x
Product is working as designed as "Report as CSV" is a report result not an attachment.
There is no functionality within email setting to attach a CSV file thus email will show CSV formated report in this scenario.
Please see KB 162988 "How to send CSV results as attachment in the Automation Policy e-mail?"