Reports

Reports are used to show data on the screen, or print it on a printer or other output device. Reports are used in (print) sessions and SQL queries. A session can have multiple reports. When you run a session that has multiple reports, a list of available reports is displayed. An SQL query can have only one report.

Example

The Print Items - General (tcibd0401m000) session has multiple reports:

  • Items - General (Details)
  • Items - General (Summary)
  • Items - General (General)

When you click Print in this session, you must select one of these reports.

Print Items - General - report selection
Print Items - General - report selection
When you select the Items - General (Summary) report, this report is printed:
Items - General (Summary) report
Items - General (Summary) report
Report structure

LN reports contain one or more of the following layouts:

LayoutDescription
Before.reportLayouts 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.
HeaderHeader layouts are printed at the top of every page.
Before.fieldYou 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).
DetailDetail 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.fieldYou 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.
FooterFooter layouts are printed at the bottom of each page.

This layout is used to print:

  • Titles
  • Page numbers
  • Page totals
After.reportThis 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.

 

The contents and layouts of reports are defined in the data dictionary. In addition, you can link a report script to a report. In a report script, you can program actions that you want to be performed at particular stages of the report execution. For example, you can create a script to perform calculations on the report data or to read records from related tables that are not automatically available to the report.

You program report scripts in the same way as you program 4GL program scripts, except that report scripts use different event sections and some special functions.

To create reports

You can create reports in the Reports (ttadv3530m000) session and in the Report Generator (ttadv3130s100) session. You can start these sessions from the Sessions (ttadv2500m000) session and from the Sessions (ttadv2100s000) session respectively.

You can change the report layout in the Report Editor that is part of Development Tools.

For details, refer to To create reports.

For more information, refer to the following topics in the Web Help:

  • Reports Overview

Related topics