Currently my Alert is an HTML table using data pointing to an SQL query.
I was wondering if it is possible to attach the resulting table from this SQL query as a PDF to the alert email.
If anyone has successfully implemented this, please let me know! Thanks!
Hi @Atanu Sarkar, I've tried using dashboards before and the export as PDF function, but got some less than desirable results. My SQL query has 11 columns, and may contain information as long as a paragraph (user input).
This works as an HTML table in an Alert since cell sizes are dynamically resized based on its contents (That way all the data is shown and fits on screen).
However, this feature does not apply to the dashboard so a good portion of the table gets cut off in both the email subscription/snapshot, and the resulting exported PDF. Please see attached screenshots - 1 shows the email subscription/snapshot being cut off, and 2 shows the PDF export being cut off.
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!