| # Report Fields (ttadv3534s000) Use this session to display the details of the layout fields in the report. 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. Link with Domain 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 ERP Enterprise (LN) Programmer's Guide 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 ERP Enterprise (LN) Programmer's Guide 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 ERP Enterprise (LN) Programmer's Guide 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. Lang/Curr.(expr) 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. Suppr. Ident. 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, or if the value of one of the sort fields change. In the Sort Field 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. Related topics Printer Information Files 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. |