Switch to: V10V9V8V7V6V5

Report Editor - Regions

Reports are divided into one or more regions, each of which may contain one ore more controls. If you have experience with other reporting tools, these are sometimes referred to as Reporting Bands. Each region has its own behavior and rules when generating the report. Populating each region with controls provides a consistent, visual framework that when printed, generates a uniform, professional document. Reports can be saved, modified and reused as templates.

Page Regions

The Page Region consists of up to three sub-regions: a Page Body and optional Page Header and optional Page Footer. Page headers and footers repeat the same content at the top and bottom of each page of the report. You can place images, text boxes, and lines in headers and footers. You can place all types of report items in the report body.

Page Header

The Page Header prints at the top of each page of the report. Much like as found in header regions in other office documents, it is possible to include controls that calculate or display information related to data appearing on the page itself, such as page number (ie page # of #), value of the current record field, calculations of aggregate functions for the page such as SUM/AVG and the like.

Page Header has an option to omit it on the first page of a report

Page Body

This is the main region for the report and can contain information for each record in your data set. printed once for every record in your data set.

Page Footer

The Page Footer region prints at the bottom of each page of the report. Much like as found in footer regions in other office documents, it is possible to include controls that calculate or display information related to data appearing on the page, such as page number (ie page # of #), value of the current record field, calculations of aggregate functions for the page such as SUM/AVG and the like.

The Page Footer region is not printed on the final page if the Final Page Footer region is used

Page Footer has an option to omit it on the first page of a report.

Last Page Footer

The Last Page Footer region is an optional region that prints only on the last page of the report.

If the Last Page Footer region is used in a report, the Page Footer region will not show on the final page.

Report Regions

Report Regions appear only at the beginning and end of a report.

Report Header

The Report Header prints only once at the beginning of the report. printed only once at the beginning of the report.

Report Footer

The Report Footer prints only once at the end of the report.

Column Regions

Your report can be divided into columns, such as columns in a newspaper. They are arranged from left to right, top to bottom, and are separated by white space between each column.

If the report is divided into more than one column, each physical page is divided vertically into columns, each of which is considered a logical page. For example, suppose you have two columns on a physical page. The content of your report fills the first column and then the second column. If the report does not fit entirely within the first two columns, the report fills the first column and then the second column on the next page. Columns continue to be filled, from left to right, top to bottom until all report items are rendered.

Columns are specified using the Report Properties. You can define from 2 to 8 columns on a page. You can read more details about column header and footer here:

Column Header

The Column Header prints at the top of each column on the page.

Column Footer

The Column Footer prints at the bottom of each column on the page.

Group Regions

Group Header

The Group Header prints at the top of each group of records.

Group Footer

The Group Footer prints at the bottom of each group of records.

Working with Regions

Enabling Regions

Using in the Report Editor Toolbar the button “Regions” you can disable/enable any standard region except group regions. The Group Header and Group Footer regions are added when you create a new group for the report using Toolbar → Data → Grouping button.

You can disable a region later if you decide it is not needed. You can use the contextual menu on a region header or toolbar for this.

Note:

  • if you disable a region that contains controls, you will be asked confirmation in the dialog.
  • you cannot disable the Page Body region.

Region Properties

You can check and modify properties of a region using Property Inspector. To select a region click its header by mouse. The header will become dark grey when selected.

Regions have as common properties, so specific to some region:

  • For example, common properties are auto_size, margin_top, margin_top, name, print, print_if, …
  • Specific properties allows you tune behavior of a region depending on its type. For example, Report Header additionally have print_on_title_page property, but Group Header have new_page.

Please read details about each property of a region in the Property Inspector section, as well as in description of regions itself.

Region Printing

 Each region has property printing that specifies if to print this report. Usually you may want disable printing of some region only temporary to see how this affects generated report to find mistake may be in another region. If you decide that you do not need a region at all, then prefer to remove it from the report using toolbar Layout commands.

Each region also has property print_if that allows you to specify a condition when to print this region.

Sometimes a region can produce empty area, mainly if SQL query returns empty result. Option print_if_empty allows still allocated designed space of the region in the generated report to save layout if needed.

Region Size

When you have a region enabled, you can resize it by mouse dragging region line, which is lower. For the last region use the grey line at bottom of page.

When you adding a control into the region, its size can be automatically expanded if needed.

Each region has auto_size property (click a region header to select a region and see its properties in the inspector). If this property is ON, then report engine self calculates the minimal required height of the region. For this it takes the topmost control in the region and the lowest one. If this property if OFF then will be used the current height of the region.

Region Margins

You can use top/bottom margin parameters of this region to allocate some empty space on its top or bottom.

For example, on the following picture you can see on left page header with 0 bottom margin, and on the right with 20. The margin area is marked by the RED line.

Note, that you can get the same effect setting either the bottom margin of page header or setting the top margin of page body region.