XLReportGen is a report generator for Microsoft Excel
that outputs reports in Microsoft Excel spreadsheet
format. If you know how to use Microsoft Excel and
write SQL statements, you can use XLReportGen to
create all kinds of reports as you need.
To create a report, XLReportGen need to read a report
template file and an XRF file. The report template
file is a Microsoft Excel workbook that defines the
layouts and formats of a report. The XRF file contains
SQL statements and some information, and tells
XLReportGen how to get data from database and how to
put data into a report. First XLReportGen creates a
blank report using the report template file, and then
executes SQL statements in the XRF file to get data
from database, and fills data into the report to
generate the desired report in Microsoft Excel
spreadsheet format.

Benefit:
* Use Microsoft Excel as your reporting tool.
* Easy to use. Just Microsoft Excel and SQL.

Download (12223 KB) Website Link to this page