# Report generator

**URL:** <https://discourse.nodered.org/t/report-generator/24150>\
**Category:** Dashboard\
**Created:** [3 April 2020 11:46 UTC](https://discourse.nodered.org/t/report-generator/24150 "2020-04-03T11:46:12Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaulL](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@PaulL](https://discourse.nodered.org/u/PaulL)\
**Post date:** [3 April 2020 11:46 UTC](https://discourse.nodered.org/t/report-generator/24150/1 "2020-04-03T11:46:12Z")

</div>

Hello,  
I have doubts about the feasibility of an idea with node-red.  
In my various flows I acquire various information from a database that I would like to put in a report and then print it from a command that comes to me from the PLC. Can I do it with node-red? Has anyone already done such applications?  
The formatting type of my report should be the one indicated in the image and printable on an A4 format  
Thanks

 ![Capture1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/d/7d6031729f99497d36c087a234db0b44e05498fd.jpeg)

---

<div class="post-metadata">

**Author:** ![Aklex1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/aklex1/32/19306_2.png) [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Post date:** [3 April 2020 12:20 UTC](https://discourse.nodered.org/t/report-generator/24150/2 "2020-04-03T12:20:04Z")

</div>

hi, you can use report builder  
use it to generate reports from the database, and output a link to this report in node red

 ![333](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/c/cc11431c360f24956d67a159b2a0d8cebabc5991.png)  
 ![44ный](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/7/e75a0075ffc4dedb0b3044fee3e815a81b7c8b62.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [3 April 2020 12:21 UTC](https://discourse.nodered.org/t/report-generator/24150/3 "2020-04-03T12:21:20Z")

</div>

Perfectly possible.

As an example, on receiving a PLC event, you grab data from database, render a report in HTML (and/or send it to a [PDF](https://flows.nodered.org/node/node-red-contrib-pdf) node) then using a cmdline action the print operation

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [3 April 2020 12:22 UTC](https://discourse.nodered.org/t/report-generator/24150/4 "2020-04-03T12:22:48Z")

</div>

What is this report builder? a node-red node? or are you referring to MS SQL Server report builder?

Only reason I ask, is the OP didn't state what kind of SQL he was using.

Cheers.

---

<div class="post-metadata">

**Author:** ![PaulL](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@PaulL](https://discourse.nodered.org/u/PaulL)\
**Post date:** [3 April 2020 12:26 UTC](https://discourse.nodered.org/t/report-generator/24150/5 "2020-04-03T12:26:47Z")

</div>

Thanks Steve,  
do you have any examples code that can help me?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [3 April 2020 12:30 UTC](https://discourse.nodered.org/t/report-generator/24150/6 "2020-04-03T12:30:43Z")

</div>

Examples of what? Getting data from Database? What kind of database? Generating a report? Printing a report? Reacting to a PLC value change? Connecting to a PLC? What type of PLC?

---

<div class="post-metadata">

**Author:** ![Aklex1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/aklex1/32/19306_2.png) [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Post date:** [3 April 2020 12:32 UTC](https://discourse.nodered.org/t/report-generator/24150/7 "2020-04-03T12:32:37Z")

</div>

you can save a report from report builder to pdf, but I don't know if you can do it all by command. in my case, the report is generated by the user because the date is selected.

Report builder  
[https://docs.microsoft.com/ru-ru/sql/reporting-services/report-builder/tutorial-create-a-quick-chart-report-offline-report-builder?view=sql-server-ver15](https://docs.microsoft.com/ru-ru/sql/reporting-services/report-builder/tutorial-create-a-quick-chart-report-offline-report-builder?view=sql-server-ver15)

[https://www.microsoft.com/en-us/download/details.aspx?id=53613](https://www.microsoft.com/en-us/download/details.aspx?id=53613)

---

<div class="post-metadata">

**Author:** ![Aklex1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/aklex1/32/19306_2.png) [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Post date:** [3 April 2020 12:33 UTC](https://discourse.nodered.org/t/report-generator/24150/8 "2020-04-03T12:33:57Z")

</div>

download report builder from the link and study the instructions from microsoft, there is a very detailed description of everything

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [3 April 2020 12:36 UTC](https://discourse.nodered.org/t/report-generator/24150/9 "2020-04-03T12:36:20Z")

</div>

yeah, I figured you meant reporting services. this assumes the OP is using SQL Server doesnt it? Or is reporting services possible to use with other DBs?

Also, isnt reporting services a paid product?

---

<div class="post-metadata">

**Author:** ![Aklex1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/aklex1/32/19306_2.png) [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Post date:** [3 April 2020 12:38 UTC](https://discourse.nodered.org/t/report-generator/24150/10 "2020-04-03T12:38:41Z")

</div>

Yes, I'm using SQL Server. report builder in my opinion is free,  
other high-load systems like BI are paid on a subscription basis  
[https://powerbi.microsoft.com/ru-ru/pricing/](https://powerbi.microsoft.com/ru-ru/pricing/)

---

<div class="post-metadata">

**Author:** ![PaulL](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@PaulL](https://discourse.nodered.org/u/PaulL)\
**Post date:** [3 April 2020 12:53 UTC](https://discourse.nodered.org/t/report-generator/24150/11 "2020-04-03T12:53:11Z")

</div>

Generating report

---

<div class="post-metadata">

**Author:** ![PaulL](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@PaulL](https://discourse.nodered.org/u/PaulL)\
**Post date:** [3 April 2020 12:54 UTC](https://discourse.nodered.org/t/report-generator/24150/12 "2020-04-03T12:54:15Z")

</div>

Thanks for your answer,at the moment i'm using the report builder but is not to easy in my opinion

---

<div class="post-metadata">

**Author:** ![Aklex1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/aklex1/32/19306_2.png) [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Post date:** [3 April 2020 13:09 UTC](https://discourse.nodered.org/t/report-generator/24150/13 "2020-04-03T13:09:13Z")

</div>

If you use report builder I can tell you how to generate a report

---

<div class="post-metadata">

**Author:** ![PaulL](https://avatars.discourse-cdn.com/v4/letter/p/3ab097/32.png) [@PaulL](https://discourse.nodered.org/u/PaulL)\
**Post date:** [3 April 2020 13:09 UTC](https://discourse.nodered.org/t/report-generator/24150/14 "2020-04-03T13:09:58Z")

</div>

ok ,thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [3 May 2020 13:20 UTC](https://discourse.nodered.org/t/report-generator/24150/15 "2020-05-03T13:20:21Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.