Field properties ("Report-writer" tab)
Set the properties in Property editor. Field properties are grouped into the General, Report-writer, and Multi-page tabs.
This section describes the Report-writer tab of the field properties.
Report writer mode
The operations in the VrSetForm mode 4 and 5 are called "Report-writer mode". In SVF Cloud, the VrSetForm function works in mode 4 or 5, which means that the report writer mode is used.
Restriction
Numeric-type fields cannot display text.
In the Report-writer mode, the output of a form is controlled according to the following report-writer settings, such as key-break, specified when designing the form:
"Report writer" has the following features:
Output sorted data
Control page breaks by using key-breaks
Auto-insert header records and total records
Control output data with an identical key (print on first page only, last page only, or print at the end of the group)
Control group-suppress
Clear accumulated value
Clear page count
Control the processing of R-type and G-type functions
Reference
You must specify a key ID in order to use the report-writer features. You can use the group suppress feature without specifying a key ID.
Setting items in the "Report-writer" tab
Properties | Description |
|---|---|
Key ID | This setting is required to use the report-writer features. With the report-writer features, you can control dynamic output on a form such as inserting records, controlling display of duplicate data (group suppress), and page break control. Specify a numeric value as the index key to be used for controlling data. If you specify "0", no key is specified. Specify the keys in order of 1, 2, 3 from the largest group to the smallest group. If the mode of VrSetForm is set to 5 or if "Sort - ON" is specified in Output mode of Universal Connect/X, fields are sorted and output according to the key ID order specified. ReferenceIf you want to check or set key IDs configured to all items by displaying a list of them, open the Batch setting of items dialog first. |
Descending order | Set the sort order for the fields for which a key ID is specified. When selected, fields are sorted in descending order. When cleared, fields are sorted in ascending order. This option is enabled when mode 5 of VrSetForm is specified. |
Page break | Specify whether to break the page at the time of key break. When selected, page break will occur. When cleared, page break will not occur. |
Header record name | Specify a record name to be printed as the header record at the beginning or on a key-break. |
Total record name | Specify the name of the record to be printed as the total record on a key-break. |
First page only | Specify whether to print the field only on the first page when printing with the same key runs across multiple pages. When selected, the field will be printed only on the first page. When cleared, the field will be printed on all pages. This feature is enabled for fields other than those in records. |
Last page only | Specify whether to print the field only on the last page when printing with the same key runs across multiple pages. When selected, the field will be printed only on the last page. When cleared, the field will be printed on all pages. This feature is enabled for fields other than those in records. |
Print at the end of group | Specify whether to print only on the last line of the detail group. When selected, the field will be printed only on the last line. When cleared, the field will be printed on all lines. |
Group-suppress | Specify whether to perform group-suppress. When group-suppress is enabled, data will be blank if the data is the same as the previous line. You can set group-suppress without specifying a key. When selected, you can set group-suppress. Example 1: When group-suppress is not used Even when the same data is repeat, the data is printed in all rows.  Example 2: When group-suppress is set for product type, product code, and customer code without specifying their keys Each field is suppressed individually.  Example 3: When product type, product code and customer code are specified as keys, and group suppress is set for each of them If the data of a higher key is changed, group-suppress is canceled even if the lower key has the same data as before.  Group-suppress is disabled when total records are output. RestrictionGroup-suppress across multiple records is not supported. |
Group-suppress off | Group-suppress works when identical data is repeated. However, you can cancel the group-suppress when the selected contents change in a field. When selected, group-suppress will be disabled. When group-suppress is disabled for Customer Code after specifying a key for Product Type, Product Code, and Customer Code If the contents of customer code change, group-suppress will be canceled for all other fields. When the data of a higher key ID is changed, the group range is fixed and a new group is started from the following data. Group-suppress off can only be set for a field with a key specified.  |
Centering on duplicated | Specify whether to print the group-suppress results with centering in the cell. When selected, the result of group-suppress that is performed on repeated data will be centered and printed.  RestrictionThe operation when used with the automatic link field is not supported. |
Suppress line on duplicated | Specify whether to suppress the frame of the record when identical data is repeated. When selected, the frame of the record will be suppressed. CautionStraight lines and rectangles that are placed on Common page and that are not at the subform level will not be regarded as border lines when suppressing ruled lines. To use them as a border line, placing them on pages other than Common page. |
Clear accumulated value | Specify whether or not to restore the cumulative total value calculated using R-type statistical functions to "0". When selected, the cumulative total value will be restored to 0. |
Clear page count | Specify whether to restore the page count to 1 when a page break occurs due to a key-break. When selected, the page count will be restored to 1. Even if the form has two or more page break keys, do not set more than one page break key per XML form file. CautionIf you want to restore the page count to 1 to output when a key-break occurs, specify to clear the page count in the key field. Also, in the field that outputs the page count, you must use <system_variable>_PAGE_CNT instead of the PAGE() function. |