Reporting - Embedded Reports into Email Notification

[tomsmith01]

I have a requirement to build an email notification report which will be sent out on a monthly basis by a scheduled job. In the notification amongst the HTML, the customer wants to embed reports rather than have them as attachments. Is this possible?

[Mike Allen]

Apart from using notification scripts and coding all the html and querying yourself, I don't think this is possible.   I have attempted to accomplish this in my dev instance and all I get is the attached report.

[tomsmith01]

I tired something like: <div style="width: 100%; height: 700px"><iframe id="report_target" name="report_target" src="/sys_report_display.do?sysparm_report_id=b99482000fe1a64022d585ece1050e3d" width="100%" height="700px" scrolling="yes">$[SP]</iframe></div>

The report is public and it shows as appearing in the mailbox of SN but doesn't show up when it reaches my inbox.

[Mike Allen]

I was able to do this using your code and notification scripts:

I just set the email to fire on event, and scheduled the event to be inserted.

[tomsmith01]

Did you get the email to your inbox or just preview it in ServiceNow? It seems to preview ok but doesn't send to my inbox, it is just an empty box with a border.