LJZsoft releases XLReportGen V3.4

June 12, 2007; 04:05 AM

The sample report generated by XLReportGen

LJZSoft announced the release of version 3.4 of XLReportGen, Report Generator for Microsoft Excel.

What is XLReportGen?

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.

System Requirements

* Microsoft Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows 2003 or later.
* Microsoft Office 97/98, Office 2000, Office XP, Office 2003 or later.

Main features

* Using Microsoft Excel as your reporting tool
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.

* Making report template directly using Microsoft Excel
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.

* Accessing to databases using SQL
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.

* Using ADO to access and manipulate data sources
Using ADO, XLReportGen can access and manipulate a wide variety of data sources such as Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Teradata, MySQL, Microsoft Access, dBase.

* Supporting Windows mode and command line mode
XLReportGen supports Windows mode and command line mode. You can use the program to create reports directly, can also run the program from other application. Using XLReportGen Development Edition (XLReportCom), developers can integrate Microsoft Excel into their application.

* Various reporting capabilities
XLReportGen provides various reporting capabilities including sorting data, grouping data, subreports, totaling and summarizing data, formatting, charting and pictures. It is easy to create simple reports, and, you can create complex reports.

About LJZsoft

LJZsoft was founded in 2003, and is located in Beijing China. LJZsoft has been providing Microsoft Office Reporting Tools.

Contact information

Support ([email protected])
Sales ([email protected])
World Wide Web (http://www.ljzsoft.com)
Phone and FAX contact is not available.