Modifying print image or PDF fields

If the properties of a field have been incorrectly identified by the Data Definition Wizard, or you want to update the properties of a field you defined, you can modify it.

To modify the properties of a field:

  1. Right-click the field you want to modify and select Edit Field. Fields are identified using blue highlighting.

    The Field Definition dialog box is displayed.

  2. Change the name of the field by entering the new value in the Name text box.
  3. Change the data type of the field by selecting a new value from the Type drop-down list.
  4. Click Advanced Options and modify any of the properties listed below. Fields that do not apply to the selected field type are disabled.
    • Starts on Line – Specifies the line number of the record the field starts on.

    • Starts in Column – Specifies the starting position of the field.

    • Field Width – Specifies the length of the field.

    • Field Height – Specifies the height of the field.

    • Decimals – Specifies the number of decimal places for numeric fields.

    • Format – Specifies the input format for datetime fields or the output format for numeric fields. You can select from existing formats in the drop-down list, or specify a different format in the text box. This property is disabled when the Character data type is selected.

      For more information, see Formats of date and time source data, or Numeric value formatting.

    • Width – Specifies the column width in ACL views and reports.

    • Alternate Column Title – Specifies the column title displayed in ACL views and reports.

    • Suppress Totals – Select the checkbox to prevent the values in the field from being totaled. By default, ACL automatically totals numeric fields in reports. You can suppress this behavior if the field contains data, such as unit prices or quantities, where calculating the total is not meaningful.

    • Control Total – Select the checkbox to identify the field as a control total field. The input and output totals of a control total field are included in the file history. The control total value is used as a check to verify that the data being used is complete and consistent from one session to the next. The value can also be used to reconcile data with external sources.

    • Convert to Single Field – Select the checkbox to specify that a character field that spans multiple lines should be processed as a single concatenated field.

    • Fill if Blank – Select the checkbox to specify that value in the first field in a set of records should be copied to subsequent records that do not specify any value for the field.

    • Ends on Blank Line – Select the checkbox to exclude trailing blank lines from a field where the number of lines in the field varies from record to record. For example, a Comment field may span 5 lines, but for some records the value of the Comment field may only be 2 or 3 lines.

  5. Click OK.


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback