Report Fields (ttadv3134s000)

Use this session to maintain the details of the layout fields in a report.

With this session you can define general data for report fields. You can specify the print expression, domain data, several conditions, color and feature codes.

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

It is possible to define more than one layout by 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 by 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.
Column

The start column number of the report field in the layout.

Row

The start row number of the report field in the report layout.

Print Expression

The value to be printed at the report layout. You can zoom to the report input field data to select an input field. Furthermore you can use any 3GL expression.

Examples

It is possible to use report script variables in the print expression.

  • maitm001.item

    Field maitm001.item will be printed
  • price / 100

    The variable "price" divided by 100 will be printed

It is possible to use the question mark in the print expression.

Syntax: condition ? expression 1 : expression 2

If the condition equals true, the expression 1 is printed, else expression 2 is printed.

Question mark expressions can be nested, so expression 1 or 2 can be a question mark expression itself.

  • flag = 1 ? tdsls041.item : tdpur041.item

    If flag = 1, print tdsls041.item, if flag is not 1, print tdpur041.item
  • flag < 0 ? (flag = -1 ? value.1 : value.2) : value.3

    If flag lower than 0 and flag = -1, print value.1; If flag lower than 0 and flag is not -1, print value.2; If flag not lower than 0 print value.3
Domain

The package of the domain of the print expression of the report field.

Domain

The domain of the print expression of the report field.

Domain

The type of the domain of the report field.

If this check box is selected, the print length, the print format and the alignment are taken from the domain definition.

If this check box is cleared, the print length, the print format and the alignment can be specified by the user.

Print Length

The length of the report field.

Default value

If the Link with Domain check box is selected, the length of the specified domain. If there is no link with the domain, the print length can be given by the user.

Print Format

The print format of the report field. You can fill the print format if there is no link with a domain. The print format can be used for the data types byte, integer, long, double, float, string (with only digits) and date.

Default value

The print format that is defined in the domain definition.

Depending on the Domain type of the report field there are three different formats.

DATE For data type is date, the following print format can be used:

  • %D<format code>
  • %-n.nD<format code> The form of this format is defined in the Date Formats (ttadv4580m000) session. Refer to the description of the sprintf$ function in the Infor ES Programmers Guide (Infor Support Portal KB 22924522) for all possibilities.

DOUBLE or FLOAT If the data type of the report field is double or float, a special amount defined in the Formats (ttadv4585m000) session can be specified using %A<format code> or %-n.n<format code>. Refer to the description of the sprintf$ function in the Infor ES Programmers Guide (Infor Support Portal KB 22924522) for all possibilities.

BYTE, INTEGER, LONG, FLOAT, DOUBLE or STRING If the data type of the report field is byte, integer, long, float, double or string the following special characters can be used defining the print format of the field: Z9+-*TVD. Refer to the description of the edit$ function in the Infor ES Programmers Guide (Infor Support Portal KB 22924522) for all possibilities.

Note: If a number on the field does not fit in the print format, the field is filled with overflow characters.
Alignment

This field indicates whether the contents of the report field must be adjusted or not.

If the Link with Domain check box is selected, the alignment can not be changed.

Minimum of textlines

The minimum number of text lines the layout contains. If this value is zero, the report manager computes the right value. With this field you can control the size of the text on the layout of the report.

Maximum of textlines

The maximum number of text lines the layout contains. If this value is zero, the report manager computes the right value. With this field you can control the size of the text on the layout of the report.

Language / Gen.Unit Expression

This field is only applicable if the value of the Print Expression field is Enumerated, Float, Double Date or Text.

Default value

  • If Print Expression field is Date, the sequence of year, month, week and day will be printed in the order as specified for the language of the report. You can overrule this by specifying another language in this field. You can do this by specifying an expression for the desired language code or a variable (e.g. a report input field, like tccom010.lang).
  • If Print Expression field is Float or Double, the display format of the default currency of the company will be used, as specified in the Companies (ttaad1100m000) session. You can overrule this currency by specifying an expression for the desired currency code on this field. You can do this by using the currency code between quotes (like "pnd") or a variable (e.g. a report input field, like tccom010.ccur).
  • If Print Expression field is Enumerated or Text, the text or the enumerate-description will be printed in the language of the report. You can overrule this by specifying another language at this field as explained above.
Supress Identical Values

If this check box is selected, the value of the print expression will only be printed, when it changes. This possibility is especially important for detail lines. The system will not suppress printing at a new page. In the Sort Field Suppress I.V. field you can specify a sort field, related to this field. When the value of this sort field changes, printing of the print expression will not be suppressed.

If this check box is cleared, the value of the print expression is always printed in the layout field.

Aggregate Function

Special operations on the print expression can be done with use of an aggregate function. These functions always refer to a group of records, depending on the layout type: footer - All records on a page. after.field - All records where the specified sort field has the same value. after.report - All records of the report. Example if you use a COUNT in an "after.report" layout, it counts all records of the report. A COUNT in a "after.field" layout counts all records where the specified sort field has the same value. A COUNT in a "footer" layout counts all records on the same page.

If an aggregate function can not be applied to all values of the print expression, you can use the Aggregate Expression field to specify a condition for what values must be taken into account.

Print Condition

The condition which is evaluated at runtime. When this condition is true the print expression will be printed. This condition can contain any 3 GL expression. It is also allowed to use report script and report input variables in the print condition. With '$$' you can substitute the runtime value of the print expression.

Examples

  • 1

    Print expression will always be printed
  • x > 0 and y > 0

    Print expression will be printed if variable x > 0 and variable y > 0
  • $$ > 0

    Print expression will be printed if the value of the print expression is larger than 0
Report Field Font

The font of the report field. You can specify standard font types or you can define font types yourself. These fonts can be defined in the printer information files of the printer that is used.

Printer Information Files

Barcode

The numeric value of the barcode type.

Barcode type value

The total numeric value of the barcode type, which is stored in the Report Output Fields (ttadv334) table, is calculated as follows:

numeric value of the Barcode field + numeric value of the Calculate Checksum field + numeric value of the Show check digits field

  • The numeric value of the Calculate Checksum field is 128, if the corresponding check box is selected. If the check box is cleared, the value is 0.
  • The numeric value of the Show check digits field is 256, if the corresponding check box is selected. If the check box is cleared, the value is 0.

See these examples:

Barcode field Calculate Checksum check box Show check digits check box Barcode type value stored in Report Output Fields (ttadv334) table
38 Selected

128

Selected

256

422
38 Selected

128

Cleared

0

166
38 Cleared

0

Selected

256

294
38 Cleared

0

Cleared

0

38
Calculate Checksum

If this check box is selected, the barcode contains a checksum calculation.

A checksum is used to detect accidental errors that may have been introduced during data transmission or storage.

Note: 

This field is only applicable for barcodes that support checksum calculation.

This field influences the total numeric value of the barcode type, which is stored in the Report Output Fields (ttadv334) table. See Barcode type value.

Show check digits

If this check box is selected, the calculated checksum is displayed in the barcode string.

Note: 

This field is only applicable for barcodes that support check digits.

This field influences the total numeric value of the barcode type, which is stored in the Report Output Fields (ttadv334) table. See Barcode type value.

Color

The color of the report field.

Bold

If this check box is selected, the report field is printed bold.

Reverse

If this check box is selected, the background of report field is printed in the specified color and the characters are printed white.

Underlined

If this check box is selected, the report field is printed underlined.