Page History
...
Pos | Name | Type | Description | Default |
---|---|---|---|---|
<0, 1> | Title | Text | The column's title text | Required |
<0, 2> | Type | Option | The column's expected data type | Required |
<0, 3> | Width | Integer | The column's initial width | Required |
<0, 4> | Autosized | Boolean | Is column autosizable flag | True |
<0, 5> | Resizable | Boolean | Is column resizable flag | same as Autosized |
<0, 6> | Image | Integer | The column's image | 0 |
<0, 7> | Sortable | Boolean | Can column be sorted flag | True |
<0, 8> | Visible | Boolean | Is column visible flag | True |
<0, 9> | MinWidth | Integer | The column's minimum allowed width | 0 |
<0, 10> | Alignment | Option | The column's data alignment | Left |
<0, 11> | Tool Tip | Text | The text to appear when the user hovers the cursor above the column's header | "" |
<0, 12> | Format | Text | The output format for the column's data | "" |
<0, 13> | Check Box | Boolean | Determines if the column has check boxes | False |
<0, 14> | Font | Font | The column's font | Tahoma, 8 pt. |
<0, 15> | Data Source | Option | Determines how to interpret column's items' values | Text |
<0, 16> | Check Box Alignment | Option | The column's check box alignment | Left |
<0, 17> | Hyperlink | Boolean | Determines if the column's items are hyperlinks | False |
...
The column's width is measured in pixels. This value determines the column's starting width. Later, when reading the ColumnList property, this value may be different if the use user has resized the column.
Autosized (optional)
The column's Autosized flag determines if the column grows and shrinks automatically when the size of the Report Table changes. For columns whose Autosized flag is True the Report Table will ensure their altered sizes remain proportional to their original sizes. Omitting this value is the same as setting it to True. This property is ignored if HorizontalScroll is set.
Resizable (optional)
The column's Resizable flag determines if the column's width can be altered by the user. Set this value to False if you want the column to stay fixed at its initial width. Omitting this value will set it equal to the Autosized value.
...
The column's Image is simply a numerical index to the image in the ImageList mean meant to appear in the column header. The ImageList property must have already been set for this value to work properly. A value of 0 indicates no image. Omitting this value will set the column to have no image.
...
Character | Displays |
---|---|
# | Significant Digits Only |
0 | Significant Digits or Insignificant Zeros |
comma | 1. If within the number, then commas separate every three digits |
2. If trailing the number, then the number is shown as an integer divided by 1000 for each trailing comma | |
period | Decimal point. The first decimal denotes the beginning of the fractional portion of the number. All subsequent decimals are treated as literals |
...
You can use any characters in the Format field, but '[', '|', and ']' are reserved characters. Any other character is treated as a literal and is displayed as is. Thus, you may use literal characters in your format to prefix or suffix the data as you choose. If you need to use any reserved characters literally, then surround your literal text in single or double quotes. If you need to display quotes, place two of them side by side. The reserved characters are interpreted as follows (assuming a value of 1):
To Display As | Use |
---|---|
True | [True|False] |
Yes | [Yes|No] |
T | [T|F] |
The value is: True | The value is: [True|False] |
, or ] when the value is True | ", or ] when the value is" [True|False] |
...
Set this value to 1 to add check boxes to the left side of each item in the column. See the ColumnCheckBox property for details. Omitting this value means no check boxes will appear in this column.
...
Setting this value sets the font for both the header and the data within the column to the same font. If you want to set the header independently of the data, use the ColumnHeaderFont and ColumnFont properties.
Data Source (optional)
Use this value to determine how the items' values are determined. Omitting this value uses the Text option, which means the item's value is simply its text. However, you can also specify CheckBox or Both. See the ColumnDataSource property for details.
Check Box Alignment (optional)
The column's check box alignment establishes where the check box is placed within the items. See the ColumnCheckBoxAlignment property for more information. Here are the values you can use:
...
The Hyperlink option can be used to turn all items in the column into hyperlinks. All you have to do is set this value to 1. If you wish to enable individual items as hyperlinks, you may use the ItemHyperlink property. Once an item is enabled as a hyperlink, the OnItemHyperlink event will fire when the user clicks on the item's text.
...
Code Block |
---|
ColumnList = "" // Fix the width of column 1 ColumnList<-1> = "ID":@VM:"Number":@VM:"50":@VM:0:@VM:0 // Let the remaining columns use default values ColumnList<-1> = "First Name":@VM:"Text":@VM:"200" ColumnList<-1> = "Middle Name":@VM:"Text":@VM:"200" ColumnList<-1> = "Last Name":@VM:"Text":@VM:"200" // Now set up the columns Set_Property(@Window:".OLE_REPORTTABLE", "OLE.ColumnList", ColumnList) |