We need to send every X days reports to our customers, telling them about their performance these days. The report includes calculated numbers and pie charts and should be sent by email. Our data is stored on MySql.
I am looking for a good tool that will help me generate these emails.
Requirements
- Be able to get arguments from outside (timeframe, customer id, etc.)
- Be able to access the datasource, and perform some queries according to the arguments
- Be able to generate multiple reports in one click, and send them by email (or export to html, we have mail server)
- Be able to generate pie charts, according to the arguments.
- Optional: free tool.
I tried jasper, but beside many bugs it has, it was too complex to generate multiple emails according to arguments.
Context
We have a web application with REST API. So, we can have a standalone application that access the DB, or standalone application that access REST API.
In addition, it can be integrated in our web application (written in java, deployed on tomcat + linux).
So we are flexible.