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

[VaibhavShinde]

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,

[geva]

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.