The All-in-One Database Software Solution

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Report Style Properties

Before reading this section, please read the Reports section. The Report Style Properties window can be opened from Report Style Editor only.

To access the Report Style Properties window, press the Ctrl+P key combination or use the Report Style > Modify Properties menu item.

This window has 3 tabs: General, Records Layout and Paper, Printer, Margins.

General Tab

This tab contains general report properties.

Report style name - this field defines the style name. This name will be used for selecting the report style before printing.
Use this report style "by default" to print... - if this option is enabled, this report will be used by default for printing database software records of this type.

Group and Sort

This tab allows setting up report sorting and database software records grouping.

Group database software records by

This option allows selecting the field by which database software records will be grouped.

The view of the Record Area in Report Style Editor will change, as it will have additional areas for the group name and for the group sub-total:

All information above the first blue line (place sub-group header here) will be printed only if the previous and the current database software records have different values in the field selected for grouping. In this case, when orders are returned, this field will contain the client name (Client).
All information below the second blue line (place sub-total here) will be printed only if the subsequent and the current database software records have different values in the field selected for grouping. In this case, when orders are returned, this field will contain the amount of orders for each client.

To calculate the sub-total for a group, use Formula Editor and functions subMathOp and subRecN.

Note: activating grouping does not imply that database software records will be sorted by the selected field. If you don't want to carry out sorting every time before printing, set it up in the report properties (see below).

Sort before printing

When this option is selected, database software records will be sorted in the order you have indicated. If they were sorted before (for example, by means of a query), the previous sorting order will be lost .

Records Layout

On this tab you can define how the database software records will be located on the sheet.

Use the 'report title' area as a title page. - if this option is enabled, a title page will be added to the report. That is, the first page of the report will contain only the content of the 'report title' area.
Print only one database software record on each page. - if this option is enabled, each page will contain only one database software record, otherwise the program will automatically break database software records into pages due to the columns settings.

Columns

With the program you can print columns in two different modes: top to bottom and from left to right:

Printing from left to right is available only if the database software records to be printed are of the same vertical size. As a rule, database software records being printed are of different sizes if the database software record area comprises elements with the Fit height to text size property.

If you select printing from top to bottom, database software records may have a different size. Also, if a database software record does not fit on one page, it will be automatically split into several database software records (see the picutre).

Top to bottom printing is recommended when you print large texts (for example, letters), or when printing into a table. Left to right printing is preferable for data of a fixed size, for example, business cards or images.

Paper and Printer Tab

On this tab you can select and set up the printer that will be used for printing the current report.

Get Information - click this button to get information about the printer that will be used for printing the report.
Configure Printer and Paper - click this button to select the printer to print the report. For each report you can select a separate printer and individual printing properties. For example, invoices can by default be printed on a laser printer, annual reports - on a color bubble-jet printer, and letters on special paper. Also, you can set up the printer right before printing by clicking the Printer... button in the Print Preview... window.
Margins - in this window you can specify the margins from paper edges when printing. The margins are not displayed for editing the report in Report Style Editor, but they can be viewed during the print preview. The measuring units can be changed in the Report Stlye Editor Properties window (Tools > Options or Ctrl+O).