Skip to main content
V
VaibhavShinde16-Pearl
16-Pearl
July 23, 2020
Question

What is best for generating periodic reports like daily, weekly , monthly etc

  • July 23, 2020
  • 1 reply
  • 859 views

Hi,

I am confused about what should i prefer to generate reports in thingworx, Javascript or SQL query(as i am using Database)? i have to generate reports based on  input like in below image.. 

 

VaibhavShinde_1-1595505194630.png

VaibhavShinde_0-1595505116873.png

if we choose javascript then how can i compare these inputs or how i can filter data based on input like month and year? i know there is Query param for query service but in query param where  can i put this month & year? 

 

Thanks,

1 reply

G
geva15-Moonstone
15-Moonstone
November 7, 2023

ThingWorx Mashups offer a good way to build a lot of dashboards, however ThingWorx doesn't have built-in report generation capabilities.

 

People typically use reporting (SSRS) or BI tools (Qlik, Tableau, PowerBI) for this, but you can also leverage different techniques like feeding data into an Excel spreadsheet (Apache POI) which would render reports, charts, etc.  We have other customers that have built a small "report" web page which they populate with data from ThingWorx and it can then be multi-page and printed to PDF and e-mailed.

 

 

Terms & ConditionsAccessibility statement