XLReportGen is a report generator to generate reports in Microsoft Excel format. If you know how to use Excel and write SQL statements, you can use XLReportGen to create all kinds of reports as you need.

XLReportGen is a Microsoft Excel utility that allows you to generate and create reports in Microsoft Excel format.

Furthermore, with one time configuration, you can easily build periodic reports such as daily, weekly, monthly and annual reports.

XLReportGen can read report template file and SQL file. Report template file defines the format of a report, and SQL file controls database access.

XLReportGen creates a blank report using report template file, and executes SQL statements in SQL files to pull data from database, and fills the cells in the blank report to generate the desired report.

Here are some key features of "XLReportGen":

· Easy-to-use and flexibility, making report template using Microsoft Excel.
· Powerfulness and flexibility, accessing database through SQL.
· Connectivity, connection to all databases using ODBC, supporting Oracle, DB2, Sybase, Informix, MS SQL Server, Teradata, MS Access, etc.
· Running multiple and different types of SQL statements ( DML, DDL ) in one report generating process, meeting complex reporting requirement.
· Running in Windows mode or command line mode.
· Automatic execution or executed by other applications.
· Configured once, report forever.
· Using Microsoft Excel as your reporting tool
· Making report template directly using Microsoft Excel
· Accessing databases using SQL
· Creating reports without programming experience
· Connection to all databases using ODBC
· Supporting multi-databases in one report
· Generating reports with parameters
· Supporting Windows mode and command line mode
· Creating complex reports
· Creating reports with charts
· Creating reports with pictures
· Many reports in one Microsoft Excel workbook
· Conversion of file formats
· Generating reports automatically
· One time configuration
· Flexible deployment

Requirements:

· MS Office 97 or later

Limitations:

· 30 days trial

What's New in This Release: [ read full changelog ]

· Added an option to insert range not entire rows/columns.
· Added an option to delete sheet when no data are returned.
· Changed the range deleting.
· Modified the image argument parsing.