Anyone generating reports with NR?


Just recently given the request to email a report of values everyday saved in MSSQL. I feel as though Node-Red could be up to this task.

They would like tables and line/bar charts to be included in the report.

Has anyone done such a thing with Node-Red?
What file format are you using/suggest?

I was thinking of generating an HTML file using a template and inserting the data with mustache and JQuery.
However, I am not too sure how to include the charts.
Would it be possible to create a chart in an html file with data retrieved with Node-Red?