Report Layouts (ttadv3531m000)

Use this session to display the layouts of a report.

Via the Specific menu, you can:

  • Edit a selected layout. Refer to Edit Layout... for details.
  • Edit all layouts simultaneously. Refer to Edit All Layouts... for details.
  • Copy layouts from another report. Refer to Copy from Other Layout... for details.

You can start the report editor to display a specific layout by marking it.

Field Information

Language

The language code of the report. When a user runs a session with a report, the report in his own language will be run.

Package

package

VRC

version

VRC

release

VRC

customer

Report

The module to which the report belongs.

Report

The identification code of the report. A report is uniquely identified by the combination of package code, module code, report code and language.

Layout Type

The layout type.

Allowed values

Before.report

Layouts of this type are printed once at the beginning of the report. This layout can be used to present information about the report. For example, the title page of the report.

Header

Header layouts are printed at the top of every page.

Before.field

You can define this layout for each input field for which a Sort Mode is defined in the Report Input Fields (ttadv3532m000) session.

Each time the value of the sorted input field changes, this layout is printed before the Detail lines. In this way the records are grouped. If a group of records spans more than one page, the before.field layout is repeated at the top of the new page (following the header).

You can suppress automatic printing at the top of every page by using lattr.break as an output expression. The lattr.break output expression is a predefined variable that contains the value 1 (true) when the sort field changes. By using this output expression, the layout is only printed when the input variable is changed.

Note: 

To define multiple grouping levels in a report, e.g. group Purchase Order records first by buyer, and then by buy-from business partner:

  • in the Report Input Fields (ttadv3532m000) session, define a Sort Mode and a Sort Sequence for each input field by which the records must be grouped.
  • Define a before.field for each of these sort fields.

The order of sorting and grouping depends on the Sort Sequence that was specified.

Detail

Detail layouts are used for the individual records included in the body of the report. They are printed every time that data is sent to the report.

After.field

You can define this layout for each input field for which a Sort Mode is defined in the Report Input Fields (ttadv3532m000) session.

Each time the value of the sorted input field changes, the layout is printed after the detail lines. In this layout, the presorted input field still contains the old value.

This layout, for example, can be used to print totals for a particular group of detail lines.

Footer

Footer layouts are printed at the bottom of each page. This layout is used to print:

  • Titles
  • Page numbers
  • Page totals
After.report

This layout is only printed at the end of the report, and after all other layouts. If this layout does not fill a complete page, the footer layout will be printed at the bottom of the page, where the After.report layout(s) is printed.

Field Name

The field name is only applicable for Before.field and After.field layouts. You can only specify fields, which are defined as a sorted input field in the Report Input Fields (ttadv3532m000) session. Before.field and After.field layouts will be printed when the value of the specified field changes.

Sequence Number of Report Layout

It is possible to define more than one layout per Layout/Fieldname combination. The layouts of the same Layout/Fieldname will be printed in the order of the sequence number of the layouts.

There are two reasons to define more than 1 layout per Layout/Fieldname combination:

  • The maximum size of a layout is 22 lines. If your layout should have more lines, you can make a second layout of the same type with a higher sequence number.
  • If a particular layout must be printed under certain conditions and another layout under other conditions, you have to define more than one layout with different output conditions.
Output Expression

The output expression is an expression which is evaluated at runtime. The result is always true or false. The expression syntax is equal to the 3 GL syntax. At the moment a layout has to be printed, the system will evaluate the output condition of the layout. Only if the result at that moment is true, the layout is printed.

Examples

  • 1

    Layout will always be printed

  • 0

    Layout will never be printed

  • print.detail = 1 or print.detail = 2

    Layout will be printed if variable print.detail is 1 or 2

  • strip$(tdsls041.cprj) <> ""

    Layout will be printed if field tdsls041.cprj is not empty
Note: If variables are used in the output expression, then those variables must be defined as input field for the report, specified in the Report Input Fields (ttadv3532m000) session.