Follow-On Topics

Related Topics

# About the Columns Tab

Click the image to view full size.

Here you specify the columns from the input recordset (see About the General Tab) that make up the table.

Recordset columns are dragged from the Task Browser to the design area. To change the column order, click and drag the relevant column to its new location.

Additional formatting is available for each column:

Object

The script for this column's data source.

Visible

By default, all columns added to the table are visible in the output. Use the Visible toggle to add a recordset column that is used to calculate a sub-total but is not shown in the final output.

Column Heading

The column heading as displayed in the final output.

Percentage Width

The width of the column as a percentage of the entire table width. By default, each column is set to `100%` so must be changed at design time to ensure best-fit.

TIP:

Set Percentage Width to `0` to force the browser to use its own sizing algorithm.

Data Format

The data format of the recordset column. Use the ellipsis button to change the format:

Text

|  | Alignment — Align the text in the column to Default, Left (default), Right or Centre

|  | Trim Trailing Spaces — Remove trailing spaces at the end of the column value

Numeric

|  | Alignment — Align the numbers in the column to Default, Left (default), Right or Centre

|  | Use System Defaults — Use the number formats as specified by the operating system hosting the King Task Centre client

|  | Select Region — Alternatively, enable this to specify the exact formats for:

|  | Region — Use the numeric formats as specified by the country selected

|  | Decimal Symbol — The symbol used as the decimal separator

|  | Decimal Places — The number of decimal places displayed

|  | Digit Grouping Symbol — The symbol or character used as the separator for hundreds, thousands, millions, and so on

|  | Digit Grouping — The format used for displaying hundreds, thousands, millions, and so on

|  | Negative Symbol — The symbol used to indicate a negative number

|  | Negative Format — The format used for displaying negative numbers

|  | Leading Zeroes — Whether a leading zero is displayed for single numbers

Date/Time

|  | Alignment — Align the date or time in the column to Default, Left (default), Right or Centre

|  | Date Format — Choose one of (Default), (None), d-MM-yyy, d-MM-yy, d-M-yy, d.M.yy, yyy-MM-d (default), d MMM yyy, MMM dd yy, and dd/MM/yyyy

|  | Time Format — Choose one of (Default), (None), hh:mm:ss, H:mm:ss (default), and hh:mm:dd tt

For ease of use, the formats shown to you use today's date and time.

Currency

|  | Alignment — Align the currency value in the column to Default, Left (default), Right or Centre

|  | Use System Defaults — Use the currency formats as specified by the operating system hosting the King Task Centre client

|  | Select Region — Alternatively, enable this to specify the exact formats for:

|  | Region — Use the currency formats as specified by the country selected

|  | Symbol — The currency symbol

|  | Positive Format — The format for positive amounts

|  | Negative Format — The format for negative amounts

|  | Decimal Point — The symbol for the decimal point

|  | Decimal Places — The number of decimal places after the decimal point

|  | Grouping Symbol — The symbol or character used as the separator for hundreds, thousands, millions, and so on

|  | Digit Grouping — The format used for displaying hundreds, thousands, millions, and so on

Hyperlink

Recordset data containing links to websites or email addresses are automatically displayed in the table.

Use the ellipsis button to change the format:

Type (Protocol)

|  | (None) — The data is not displayed as a hyperlink

|  | (Auto) default — The hyperlink type is interpreted by the software and a suitable hyperlink type used

|  | http:// — Links to a web page

|  | file:/// — Links to a file

|  | ftp:// — Links to a file on an ftp server

|  | mailto: — Opens a new mail message

Hyperlink

The script for this column's data source.

Open in New Window

Whether to open the link in a new browser window. You can then specify the window's dimensions in pixels.

Sub Total

If the recordset column is either of Numeric or Currency data format, you can choose to add the values and display the value in a new row.

Use About the Columns Tab to add a new sub-total row and value for a new set of table rows,

Section Break

Although available for every column, a section break should only be enabled for "sort" columns in either the Database Query (ODBC) or Database Query (OLEDB) task step. Every time the value of the column changes, a section break is added. This is particularly useful when using sub-totals.

Grand Total

If the recordset column is either of Numeric or Currency data format, you can choose to add the values and display the value at the bottom of the table.

Copyright © 2018 Quadrant Software B.V. All rights reserved.