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.

Related topics

 

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

A set of related modules that implements a complete part of the functionality, for example, Enterprise Planning, Financials, or Warehousing. Packages are designed to function as independent as possible, to enable a customer to implement only particular packages.

A package code consists of two characters. For example, tt is the code of the Tools package.

Each package has a unique version structure, the VRC structure.

VRC

An upgrade of a package, for example, B61. Each change in the functionality of a package results in a new version. A version can contain several releases.

VRC

An update in a version. For example, 'B61 a', where 'B61' represents the version code, and the 'a' represents the release code. Each update results in a new release with a new release code.

VRC

A code that identifies a customized software package. For example, B61O_a_cus1, where 'B61O' represents the version, 'a' represents the release, and 'cus1' represents the customer extension of the customized software.

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.

Link 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
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 ERP Enterprise (LN) Programmer's Guide.

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 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.

SSRS 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 Business Intelligence Development Studio (BIDS). For details, see:

    • Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services Development Guide (U9657 US)
    • Infor Enterprise Server Plug-in for Microsoft SQL Server Reporting Services Administration Guide (U9656 US)
  • 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 (U9751 US)
    • Infor Enterprise Server Connector for Infor Reporting Administration Guide (U9750 US)

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.