XL Report Builder is a versatile software that allows users to create extensive reports of varying complexity in Microsoft Excel format.
XL Report Builder offers several features to display information in users' reports. These features include absolute and conditional formatting, automatic filter, summary tables, charts, calling of the VBA-macros, and more. Users can take advantage of these opportunities to create visually appealing reports.
What sets XL Report Builder apart from band-oriented report generating programs is the fact that it doesn't use such concepts as Footer, Header, and Detail. The whole process of report creation consists of two simple operations. The first operation is pointing out data sources, necessary for the report creation. Users can choose data from different databases using SQL-queries. The second operation is creating the book-template in Microsoft Excel (XLS-template). The template contains the description of the report form, book options, sheet options, and options of the separate areas of the report. There are some specially pointed out areas in the template, where (at creating the report) the data will be put.
When the report execution process is started, XL Report Builder loads a template, fills in marked beforehand cells by the data from the pointed out sources, and shows Excel on the screen. Users can then print the report or save it on the disk as an .xls-file for further work or analysis. Overall, XL Report Builder is a great tool for anyone looking to create professional and customizable reports quickly and easily.
Version 2.1.4: Improved SQL-editor. Format of report file (.xrb) changed to XML
Version 2.1.3: Improved SQL-editor. Format of report file (.xrb) changed to XML
Version 2.1.1: Improved SQL-editor
Version 2.1.0: Direct connection to the Microsoft SQL Server.
Version 2.0.2: Some improvements in interface