User manual LJZSOFT XLREPORTGEN BROCHURE

[. . . ] n Saves money You do not need to buy extra costly reporting tools. No training is necessary because everyone uses Microsoft Office. n Saves time -1- Reduce development time and training time. n Improves productivity More productive when reports are in familiar formats like Microsoft Excel spreadsheet. n For various users For IT users, you know Microsoft Excel and SQL, it is enough. [. . . ] 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. n 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. n Creating reports without programming experience You know how to use Microsoft Excel and how to write SQL, it is enough. It does not require programming to create reports. n Connection to all databases using ODBC XLReportGen connects to databases using ODBC. Access to all databases which support ODBC such as Oracle, DB2, Sybase, Informix, Microsoft SQL Server, Teradata, MySQL, Microsoft Access, dBase. n Supporting multi-databases in one report XLReportGen supports multi-databases in one report. You can get data from -3- some different databases such as Oracle, DB2 and Microsoft SQL Server, and put these data into one report. n Generating reports with parameters XLReportGen gives you an opportunity 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. n Supporting Windows mode and command line mode XLReportGen supports command line mode. So it is possible to call XLReportGen from other program. For developers, you can integrate XLReportGen into your application. n Creating complex reports You can create complex reports. The complexity might come from report formatting as well as report content. [. . . ] Create a report template file using Microsoft Excel, define the layouts, styles, formats of reports. For example, to create a Customer List report, you make a report template as follows. Step 2. Create an XRF file with an . xrf extension using XLReportGen. The XRF file tell XLReportGen how to extract data from database, and where and how to put data. [. . . ]