XL Report Builder

XL Report Builder is a powerful and flexible tool that allows users to create reports of any level of difficulty in the form of the Microsoft Excel Book. With XL Report Builder, users can extract data simultaneously from several databases and form a report on the basis of this data. Users can use any database servers that have ODBC-drivers as the data sources. The result of the program's work is a Microsoft Excel book, which means that users can use all the power of Microsoft Excel to give visual appearance to their data.

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.