Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
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..
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,
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.