Report Designer: Page Controls

Drag an element in the right pane to change its positioning properties, such as height, left, or top.

Page Control Property

Description

Group:

Properties for the whole group (page, detail section).

After Query

Before Query

Defines plug-ins or functions that are executed before or after the query. For example, you can write data to a temporary file and then print this file. Alternatively, you can change to another job state to print a parcel list with the state before and after the modifications.

Glue

Keeps all content together on the same page, as far as possible. If no space is left on the current page, the “glued” group is printed on the next page.

Select True to print all group sections (head, body, foot, and their children) on the same page. The default is False.

Parallel

Prints one group on the left and another group on the right side of the report. This works like a layer where the second group is printed over the first one. Set to True to print a group parallel to another group.

Repeat Head On New Page

Prints the head section of a group on every new page.

Reset Page Count

Sets the page count to 1.

Show Foot

Show Head

Shows or hides the foot or head section. Hide unused sections to avoid clutter.

SQL

Defines an SQL statement to retrieve the data for the current section. Click the property row, and then click to open the SQL Assistant.

See also Use the SQL Assistant and Report Designer: SQL Statements.

SQL Source

Selects the source of the data, by default, Database. Select Memory or Plug-In to use data that an application developer stores in memory in a data table object. This is useful for preprocessing when you cannot directly use a database table for output. Memory requires use of the API

Suppress If No Records

Suppresses the head and foot section if the body section is empty because there are no records available.

Section

Specifies properties for the head, body and foot section

Glue

Keeps all content together on the same page, as far as possible. If no space is left on the current page, the “glued” group is printed on the next page.

Select True to print the section (head, body, foot or their children) on the same page. The default is False.

Height

Specifies the height of the section.

Zone:

Specifies the properties of the section zone.

Autosize

Controls the height of the zone. Select True to calculate the height of the zone based on the controls that are inside. Note that this takes effect only at runtime, but not during the design.

Height

Specifies the eight of the zone. Optionally, use the AutoSize property.

Page Break Before

Starts the section on a new page. The default is False.

Suppress

Suppresses the zone under certain conditions. The condition can be a function or a select that produces either true or false (0 or 1).

If the condition is True, the zone is suppressed.

Control

Specifies the properties of the particular controls. See also

Report Designer: Text Control

Report Designer: Picture Control.

Report Designer: Line Control.