columnSortOption

Gets or sets whether to sort by a given column, as well as whether to sort in ascending or descending order. The property accesses a collection of column sorting options. Each item in the collection applies to the corresponding item in the columnContents property’s collection of columns.

Valid values for this property are represented by the HFMConstants type library constants listed in Journal Report Sort Option Constants.

Tip:

To exclude a column from the sort order, use the NUM_JOURNALREPORT_SORT_FLAGS constant.

Read-write.

Syntax

<HFMwQueryDef>.columnSortOption(lColumnIndex)

Argument

Description

lColumnIndex

The index of the column in the collection of the columnContents property’s columns.

Input argument. Long subtype.

Example

columnSortOption is used in the example for columnContents.