Table View

Specifies the sorting and filtering for the data item.

To open this window, on the Tools menu, choose Object Designer, choose Report, choose the Design button, choose a DataItem, and then on the View menu, choose Properties. Locate the DataItemTableView property, and then choose the AssistButton in the Value column.

Fields

Field Description

Key

Specifies a table key on which you want to sort the data in the report or choose the Up Arrow button to select a key from the Key List window. If you specify a key, then this data item does not have a FastTab on the request page, and end users cannot select a key for sorting, sort order, or filters for the data item.

Order

Specifies the sort order by choosing either Ascending or Descending from the drop-down list. If you specify a sort order, then this sort order is used for the report regardless of the sort order that the end user selects on the request page.

Table Filter

Specifies a filter expression to use to filter the data in the report or choose the AssistEdit button to enter a filter in the Table Filter window. If you specify a filter, then this filter is not displayed on the request page, but it is used along with any filters that the end user specifies on the request page.

See Also

Reference

DataItemTableView Property