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?
would also like to know more. @seth350 did you find any solution to this?
I ended up using html and JQuery to list the data in table format.
It’s not pretty but it gets the job done.
Hi,
Depending on how complex (and many other factors) the report needs to be... you might use something like Grafana if you need to share reports and have lots of customization requirements.
Simple charts / graphs included with Node-RED Dashboard would be fine for simple needs. You can use techniques like embedding pages in iFrames and Dashboard template nodes to add a bit 'extra'.
Cheers,
Paul
Hi, @seth350 good to hear that. can you share any references to start with this? I want to have customized reports in excel or pdf format. would like to explore this.
Thanks
