Allow Dynamic Return Structure

N/A

N/A

If selected, switches from static to dynamic mode. In this mode, the system renders all columns in the query. The user can define additional columns, and specify a user-specific column name query in Alternative Column Name Query field.

Note that the Add Empty Row button is enabled only in dynamic mode.

Column Name Query

N/A

N/A

Allows to identify which query is used to get the data

Alternative Column Name Query

N/A

N/A

When the query is loaded, provides alternative column names

Column Number

N/A

Integer

Identifies the column

Column Name

DisplayColumns

String list

Descriptive name for the column

Heading

ColumnHeadings

String list

The label for the column.

The text entered is displayed as column heading in the grid. Each line separated by a line feed is a heading for each column.

Width

ColumnWidths

Integer list

If automatic scaling is not enabled, the width value specifies fixed widths for each column. For example, ColumnWidths=10,24,6,0,5. To hide a column regardless of the auto-scaling setting, set the width to zero.

Format

ColumnFormats

String list

Specifies the format for numeric data for each column. You can define date format, currency and percentage values and values with different decimal precision. You must provide a generic format for non-numeric columns.

Alignment

ColumnAlignments

String list

Specifies horizontal text alignment for each column.

Boolean

ShowColumnAsBoolean

String list

Specifies if the column should be displayed as a checkbox in the grid. For more information about Boolean values, see Boolean Types.

Allow Column Resizing

AllowColumnResize

Boolean

If you select this checkbox, you can resize the columns at runtime. Changes to column widths are not persistent; therefore, when the grid is updated, the widths default to the original values.

Center Column Headers

AlwaysCenterColumnHeadings

Boolean

If you select this checkbox, the column header text is centered. If the checkbox is not selected, the alignment of the column header text is based on the alignment of the column data types or the Alignment property.

Freeze Column

FreezeColumn

Integer

Allows you to freeze columns horizontally so that the columns are visible when scrolling. For example, if you have specified 2, the first 2 columns will be locked.

If you have specified row heading in Row Heading column, then the specified columns along with the row heading column are locked.

Link

Link

String

Allows you to edit the link of any URL. You can browse for a link from the MII content using Reference button. The Add Parameter button allows you to add a parameter to the link by entering a parameter name, selecting value from a column, grid parameters, or enter a string directly in the Reference field.

You can display the reference either in home page, or on top, or in new window by choosing one of the option in Target field.