|Chapter 1 Introduction|
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. XLReportGen creates a blank report using the report template file, executes SQL statements in the XRF file, and puts the data from database into the report.
XLReportGen includes the following features:
Just use Microsoft Excel as your reporting tool. You design reports like layouts, formats and styles directly using Microsoft Excel. And you will get reports in Microsoft Excel spreadsheet format as a result. Microsoft Excel is powerful, flexible and familiar. You do not need to buy and learn extra reporting tools.
The main advantage of using XLReportGen is based on the fact that all formatting is done directly in Microsoft Excel. You can take full advantage of Microsoft Excel including cell formatting, formulas, filtering and sorting, drawing and pictures, charts, multiple sheets, page setup, headers and footers, preview and printing, VBA, macros, and more.
Open XML is an open file format for the core document-oriented Office applications. It facilitates document creation and manipulation in server environments where you do not need to install the Office client applications.
XLReportGen executes SQL statements to extract data from database. Supports all type SQL: DML, DDL and DCL. Multiple SQL statements can be executed in one report building process. You can perform queries on databases, insert data into databases, and create database objects like tables. The power of SQL can be harnessed for maximum efficiency in reporting.
If you know how to use Microsoft Excel and how to write SQL, it is enough. It does not require programming to create reports.
Using ADO.NET to connect to databases, XLReportGen is independent of database systems. It can access to almost all of databases such as Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Teradata, MySQL, Microsoft Access and dBase through OLE DB and ODBC.
XLReportGen supports multi-databases in one report. You can get data from some different databases such as Oracle, DB2 and Microsoft SQL Server, and put these data into one report.
XLReportGen enables you to create reports with parameters. You may use parameters in SQL statements. You will be asked to input the values of parameters while creating reports.
XLReportGen supports command line mode. So it is possible to call XLReportGen from other program. For developers, you can integrate XLReportGen into your application.
You can create complex reports. The complexity might come from report formatting as well as report content.
XLReportGen enables you to include sophisticated, colorful charts in your reports. You can use charts any time you want to improve the usefulness of a report.
XLReportGen can insert pictures from the graphics files, position and size the pictures according to your instruction.
One Microsoft Excel workbook may contain many reports. You can generate a book of reports in one generating process.
The process of report generation can be fully automated, periodically or on events. XLReportGen can be scheduled with Windows Scheduled Tasks or other tools.
With one time configuration, you can repeatedly generate reports especially periodic reports such as daily, weekly, monthly and annual reports.
XLReportGen can be run on your desktop or server.