Changing display options for a column
You can define formatting options for a column if you want data to display differently than the defaults you defined for all columns. Use this procedure to change column defaults such as the number of decimals that display, whether values include comma separators, values are rounded, or a column is underlined.
This procedure overrides defaults that you define using the Column Defaults tab on Define Format (RW20.2). You set these defaults as part of defining a new format. See Defining a report.
- Access Format (RW20.1).
- Inquire on the format that includes the column that you want to change.
-
Click More next to the column that you want to change
to access Column Options (RW20.3).
Note: The column defaults the display that you selected on RW20.3. Unless overridden here, columns derive their default information from the options defined on RW20.2.
-
Override the column defaults that you defined on Define Format (RW20.2). Use these guidelines to specify the field values:
- Decimals
-
This field determines the number of decimals for column amounts. For example, if you select 2, then the value 100 appears as 100.00. You can select from 0 to 5 decimals.
The default is 0 decimals, which rounds the number up or down to the nearest whole number. For example, the value 99.50 would appear as 100 and the value 99.49 will appear as 99.
- Separator
-
This field determines if a separator, such as a comma, is used in column amounts. For example, if you select Yes, then the value 1000 appears as 1,000 if you have a comma set up as your separator default in your locale definition (locdef). For more information on locale definitions, see the Lawson Administration: Translation Guide.
- Negative Value
-
This field determines how negative values are represented in the report.
-
Select Dash to have a negative value appear as $200.00-.
-
Select Credit to have a negative value appear as $200.00CR.
-
Select {Brackets} to have a negative value appear as {$200.00}.
-
Select <Brackets> to have a negative value appear as <$200.00>.
-
Select Unfavorable to have a negative value appear as $200.00U.
-
Select None to have a negative value appear as $200.00.
-
- Symbol
-
This field determines the symbol that appears in the first line for each row in the column, in the row total, and in the first line in the next row following the total. A common example of a symbol is the dollar sign ($).
- Rounding
-
This field determines how values are rounded. You can select None, Hundreds, Thousands, or Millions. For example, you can select Thousands to have the number 300,000 appear as 300.
- Totaling
-
This field determines how column totals are calculated and printed:
-
Select Sum Down to add the net or rounded result of each value.
-
Select Recalculate to add the original or unrounded amount of each value.
-
Select Do Not Print to exclude print totals.
-
- Blank When Zero
-
This field determines whether lines, where all values are equal to zero, print as 0.00 or as blank. The default setting is No, which prints 0.00.
- Underline
-
This field determines whether columns are underlined. To underline columns, you must select Yes in this field and set the row line type to Underline on Rows (RW10).
If you select No, then an underline will not print even if the row line type is set to Underline on Rows (RW10).
- Offset Total
-
This field determines on what side totals are justified. You can justify totals to the left, to the right, or not at all.
- Ignore Reversal
-
This field lets you override the option you selected in the Sign Reversal field in Rows (RW10).
- Dr, Cr Balance
-
This field determines how the column totals appear. The default setting is Net Balance, which prints the totals normally. You can also select Debit Only, Credit Only, Net Debit, or Net Credit.
- Ghost Column
-
You can flag a column as a ghost column to prevent it from printing on a report. See About using a column for calculation purposes only.