How to remove the attachments from the scheduled email report table

[Shubha2]

Hi All, When we use Scheduled Email reports to send reports in an email to the users, sends the email with attachments.(pdf, csv, etc)  Is it possible to remove the attachments feature in the Scheduled reports. How do I achieve this?

The idea is, schedule the report email, with a link and not attaching any reports along with it. 

so that the users will get an email with the link which will be pointing to the report 

Any help would be appreciated. 

Thank you

Shubha

[Syvo]

Hey Shubha,

I don't know if you implemented this ultimately, but I found this thread so I thought I'd share what I did for a similar use case.

The objective was to remove the report file from the email and replace it with a link, so that data is not sent through email servers on which we have no control.

First I tried removing the sys_email_attachment record but that was not enough.

I had to break the direct link between the sys_attachment and the sys_email records with Business Rule, like SN does for files added to attachment fields, by renaming the "table_name" from sys_email to ZZ_YYsys_email.
In addition, an ACL allows read access if the email adresse of the user is in the recipients of the parent email.

I can't share the code but let me know if you need some explanations.