Here is an overview of how you can accomplish this from start to finish with i-net Clear Reports.
Create a “report template” defining the structure and data of your report, feed it into your i-net Clear Reports server and have your report be shown in the HTML Report Viewer. Alternatively you can export it into a number of formats such as PDF, XLSX, CSV, and many others. Using the Task Planner it is possible to set up automatic report generation and have the reports be sent by email, stored on an FTP server, or archived away.
Report templates are zipped, XML-based files and can be created in a number of ways.
The i-net Clear Reports server is completely written in Java, meaning it can be run on any platform that supports Java. It can make use of various report cache systems such as a hard drive or database cache. Also it can be used in failover or load-balancing clusters for high load or failover scenarios.
The data for the reports can be fetched from any JDBC data source. Note that there are JDBC drivers available for all major databases such as MySQL, MS SQL Server, Oracle, PostgreSQL, SQLite, and so on. Many drivers are already included with i-net Clear Reports.