Reports (ttadv3130s000)

Use this session to maintain reports. A report is used to output data within the database. A report consists of input data, layouts and may have a report script. Each layout can exists of report fields, special fields, labels and layout texts (prompts etc).

On the second form you can modify the report size data like margins, page sizes and fonts.

Field Information

Language

The language code of the report. When a user runs a session with a report, the report will be printed in the user's language if available.

Package

package

VRC

version

VRC

release

VRC

customer

Module

The module code of the report.

Report

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

Linked to Language

This field is not used anymore, since Label Translation Support (LTS) has been introduced.

Label Code

The code of the label that contains the report description.

Report Type

The report type.

Allowed values

4GL Report

A report that is used to print data from the database to a variety of devices (for example, printers, displays, and files).

A 4GL report must be linked either to an LN print session or to an LN SQL query. The print session or SQL query reads the data from the database tables and the report object prints the data.

A 4GL report consists of a layout part and, optionally, a report script. You can edit the report layout in the LN 4GL Report Editor.

For more information, refer to 4GL Reports Overview.

Note: You can convert 4GL reports to XML report designs. Subsequently, you can enhance the report designs in the Infor LN Reporting Studio. For more information, refer to Session-based Reporting.

Query Based Report

A report that runs a query, created in the Reporting Studio, to read data from the LN database. The report displays its output in the LN Report Viewer.

You can edit the report design in the Reporting Studio Report Designer, which offers various useful features. For example, you can create crosstab reports, and add various chart types to your reports.

For more information, refer to Query-based Reporting.

Report Library

A library, which contains shared report elements that are used by query-based reports.

To edit report libraries, and to link them to query-based reports, use the Reporting Studio.

For more information, refer to. To create report libraries.

User

The designer of the report.

Date

The date that the report is created.

Report Size

The size of the report.

Tools Interface Version

The Tools Interface Version (TIV) number of the report. The TIV number is used to guarantee backward compatibility and is related to a particular version of the porting set, the Infor Enterprise Server and the 4GL Tools. For example, the TIV number for Infor Enterprise Server 7, delivered together with LN 6.1 F1, is 1010. When you insert a new script, the TIV is automatically set to the highest supported TIV number.

By setting a TIV number for each object, the behavior of these objects can be different for incompatible features executed with different versions of the porting set or the LN Enterprise Engine.

For details about the TIV, refer to the Infor ES Programmers Guide (Infor Support Portal KB 22924522).

Script Present

If this check box is selected, an additional script is present for this report.

Expired

If this check box is selected, the report is expired for this package VRC and its derived package VRCs.

Tech.Documentation

If this check box is selected, a technical documentation description is available.

RPT Design Present

If this check box is selected, the report has an XML report design. You can edit the report design in the Infor LN Reporting Studio.

For more information, refer to Session-based Reporting and Query-based Reporting.

Available in IER

Select this check box if the report has a corresponding Infor Enterprise report design in Infor Reporting.

External Report Design Present

If this check box is selected, the report has one of these external report designs:

  • A Microsoft SQL Server Reporting Services (SSRS) report design

    You can edit the report design in Microsoft SQL Server Data Tools (SSDT). See:

    • Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services Development Guide
    • Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services Administration Guide

  • An Infor Reporting report design

    You can edit the report design in Report Studio. For details, see:

    • Infor Enterprise Server Connector for Infor Reporting Development Guide
    • Infor Enterprise Server Connector for Infor Reporting Administration Guide

To see which external designs are present for a report:

  1. Start the Reports (ttadv3530m000) session.
  2. Select the report.

  3. On the appropriate menu, select Additional Files. The Additional Files (ttadv2570m000) session starts.

    Additional files of type RDL File are SSRS report designs.

    Additional files of type IRPACK File are Infor Reporting report designs.

Release Notes

If this check box is selected, a release note description is available.

Top Margin

The number of blank lines at the top of each report page.

Bottom Margin

The number of blank lines printed at the bottom of each report page. These lines are printed just after the footer section.

Left Margin

The number of blank spaces at the beginning of each report line. This left margin will be added to the left margin specified in your report script.

Foot Margin

The number of lines allocated for the footer. If this value is -1, the footer margin is calculated by the report writer. When you have a number of different footer layouts of different sizes which are executed on conditions at runtime, it is difficult for the report writer to calculate the footer margin. So in such a case you have to specify a number of lines for this margin.

Nr. of Multi Col.

The number of adjacent columns.

This is useful for printing labels (e.g. addresses of customers).

If the number of columns is 0 the report generator computes how many columns fit on one line.

Repeat expression

The repeat expression is an expression which is evaluated at runtime. The result is a numeric value indicating the number of times each layout on the report will be printed.

Example

  • 2

    The report layout will be printed 2 times.
Note: If variables are used in the repeat expression, these variables must be an input field for the report.
Page Length

The total page length including top and bottom margin. If this value is -1, the report can be printed on paper types with different page length.

Page Width

The page width of the report excluding the left margin. This page width will be used to set the default width for new report layouts. It is also used for calculating the number of columns of a multi-column layout.

Font (default)

The font of the report. This is a default for all report layouts. These fonts can be defined in the printer information files of the printer being used.

Fixed Font (default)

If this check box is selected, the specified font can not be changed when selecting the device at runtime. But it is possible to specify different fonts for each layout separately in the Report Layouts (ttadv3131s000) session.

If this check box is cleared, it is possible to select another font for the report when you select a device in the Select Device (ttstpsplopen) session. Each layout is printed with the same font. By default the report font will be used.

Related topics