XL Report Builder differs from the Band-oriented
report generating programs by 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 is pointing
out data sources, necessary for the report creation (choosing
data from different databases using SQL-queries), and the second
is creating of the book-template in the Microsoft Excel
(XLS -template).
A XLS-template contains:
Description of the report form
Book options
Sheet options
Report separate areas options
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
will load a template, fill in marked beforehand cells by the data
from the pointed out sources and will show Excel on the screen.
After this you can either print the report or save it on the disk
as an .xls-file for the further work or analysis.
|
XL Report
Builder is a powerful and flexible tool for creating reports
of any level of difficulty in the form of the Microsoft Excel Book.
XL Report Builder allows to extract data simultaneously from several
databases and to form a report on the basis of this data. Any database
servers, which have ODBC - drivers, can be used as the data sources.
The result of the program’s work will be a Microsoft Excel
book, that’s why when creating a report you may use all power
of the Microsoft Excel to give visual appearance to your data. Absolute
and conditional formatting, automatic filter, summary tables, charts,
calling of the VBA - macros – and it’s not a full list
of opportunities, which Microsoft Excel gives you for displaying
of the information in your reports.
XL Report Builder also gives
an opportunity to create reports with parameters. The user is asked
to specify parameter points at every report creation. If you need
to create several reports, which slightly differ in one value, you
can specify this value as a “Parameter”. Every time
at creating such report XL Report Builder will ask the user to specify
this parameter point and then will put it into the report.
XL Report Builder supports the command line interface,
giving by this a lot of really unique opportunities for the developers.
Now you can call the XL Report Builder from your program, using
the command line to specify all parameters, necessary for the report
execution. Besides that, you have an opportunity to hide the main
form of the XL Report Builder and get only a result of the report
execution as a MS-Excel book.
XL Report Builder has a well-thought-out information
representation. It allows to learn how to work with this program
easily and as quickly as possible. You can use this program to solve
real tasks soon after getting acquainted with it.
|
back to the XL Report Builder Main page
