User Interface


The Report Formatter uses a word processing-styled interface, with buttons commonly found for formatting text (right align, left align, center align, etc)

Supporting report sections (bands): Page header, Report header, Group break, Group header, Detail, Group footer, Report footer, and Page footer. Each band can contain an unlimited number of Frames to represent information.




Frame contents may be a text string(s), or a formula. This is similar to Microsoft Excel usage: if the frame contents begins with the equal sign "=" then it means the rest is the formula to evaluate. In that way you can reference the only one variable as well as the expression containing as many variables and functions as you want.

Use borders around the Frames to make them standout. For example, you can place a border around dollar totals at the bottom of reports. You can also use all the Frames with borders and join Frames side-by-side to get grid-style report. Frame borders may have varying thickness and color. Also the whole frame can be filled by selected color.

You may select a font typeface, size, style and color for the whole report or report section as well as for individual frame. Use different fonts and font types to make key data stand apart from other data.

You can select multiple Frames at the same time for repositioning or alignment operations.

Frame contents are placed and aligned both vertically and horizontally.

Print the current page number as well as the total number of pages on each page header/footer.

Print the number of database records printed on the current page (useful for page footer information).

The application developer can change the language from "English", "Russian" or any other interface language. The FRB_NLS.INI file is provided for translation of all the messages and prompts that the Report Builder uses to interact with end-users.

The application developer can make available for end-user use additional functions to be used in report runtime evaluated expressions.

Ability to export report pages in WMF format to Microsoft Word for Print Preview, Edit, Save as *.doc format file, Printing purposes, etc.

Add graphics to a report that are stored on your computer. This is a GREAT feature commonly used for office letterhead, computer-generated invoices, etc.

Support for Inch as well as for Metric coordinate system.

Ability to customize default properties of a new Frame.

It is possible to set the percent values both for Horizontal and/or Vertical scaling of a whole report page being generated. Default percent value = 100%, effective increment/decrement step = 5%. X and Y percent values are stored in the user's WIN.INI file for each installed printer separately. This unique Report Builder capability allows endusers to adjust the actual size of report controls/whole report page on a hard copy for an any specific printer, such as Laser, Matrix and so on.

The "Trailing Text" feature is helpful for a MEMO field printing. The “Trailing text” option is selectable as a property of a report section (band). Text will be printed line-by-line beneath the band with page overflow control. This feature can handle a text of unlimited length.


This an image of the Report Builder "Report Formatter" tool, which all reports are created.


Whenever you create a new report or modify an existing report you will be using a "Report Formatter" to place item(s) in the desired location. The screen is very easy to use, with a toolbar of commonly used commands, a pulldown menu, and use of the right mouse button to modify item(s) on the screen. Here is a sample screen "painter"; place the mouse button over an item - if the mouse cursor changes to a hand you can left click the mouse to see what the item does: