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?"