User manual LJZSOFT XLREPORTGEN BROCHURE

[. . . ] 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. Benefit n Use Microsoft Excel as your reporting tool You have installed Microsoft Office in your computer, and you almost use Microsoft Office every day. You are familiar with Microsoft Excel, and already know how to use it. n Powerful and flexible XLReportGen is powerful and flexible because Microsoft Excel and SQL are powerful and flexible. [. . . ] And you will get reports in Microsoft Excel spreadsheet format as a result. n 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. n Accessing to databases using SQL XLReportGen executes SQL statements to extract data from database. 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. 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 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. The complexity might come from report formatting as well as report content. n Creating reports with pictures XLReportGen can insert pictures from the graphics files, position and size the pictures according to your instruction. n Many reports in one Microsoft Excel workbook One Microsoft Excel workbook may contain many reports. [. . . ] For example, you create an XRF file, and write a report function and SQL as follows. /* Customer List */ @F1=Report(sheet="Customer List" type=var cell=A6 reserve=2) SELECT CompanyName , CityName -5- , CountryName , ContactName FROM Customers, Cities, Countries WHERE Customers. CityCode = Cities. CityCode AND Customers. CountryCode = Cities. CountryCode AND Customers. CountryCode = Countries. CountryCode ORDER BY CompanyName, CityName, CountryName Step 3. Run XLReportGen to generate a report file in Microsoft Excel spreadsheet. The report Customer List is generated as follows. -6- System requirement n Microsoft Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows 2003 or later. [. . . ]