<< Click to Display Table of Contents >>

Reporting

Top Previous Next

The Reporting dialog is available from both the SQL Results Grid and the Tables | Data Contents sheet. In either place, it can be invoked by pressing the Report icon: Reports, or by right-clicking on the grid and choosing Report from the context menu. This causes the following dialog to appear:

Reports

To create a basic report, you can set three options at this point. Number of Lines in Header refers to the number of lines to be allocated for each column heading.

By default, the column heading takes on the name of the column or alias, and extends as far horizontally as necessary.

In the following example, only the orientation and the report title have been changed from the default values.

The facility then executes, and presents a preview window that will look something like this:

Reports2

Across the top of the page are a number of icons that tell what you can do with the preview window: for example, save, print, page setup, find, and close the preview window.

One glaring problem with the default report is that some job names are truncated. To correct this, we need to use the Report Designer, by exiting the Preview window, and checking the Show Designer box the next time. The Designer interface should seem familiar to anyone who has ever worked with any kind of object-oriented report design program. Here, the JOB column has been increased in width and a popup has been used to rename the report:

Reports3

 

The SAL and COMM columns have also been formatted with two decimal places, producing the following result:

Reports4

For anyone who has ever worked with a report designer, these changes are rather intuitive to make.

When you have tailored the report format as you want it, you can use Save As from the File menu to save the report format as an .frf file. The next time you want to create a report based on this format, choose the Report Designer, and click the Open icon on the toolbar to apply the saved format.

Click the preview icon to view your design and content. Note that you can not only print your finished report, but also save it in a variety of formats, such as .pdf, HTML, .rtf, and several image formats.

Here we cannot describe all the various possibilities for formatting a report in the KeepTool help file. This information is available, however, from FR-Software, the maker of the report component, at

http://www.fast-report.com/en/documentation/frx3user/index.htm.