The following screenshot is a column property screen showing the Bin Code column for our simple query:
The properties shown in the preceding screenshot are as follows:
- Method: Can be Sum, Count, Avg, Min, Max, Day, Month, or Year. The result in the column will be based on the appropriate computation. See the Help section for Method Property for more information.
- ReverseSign: This reverses the sign of the column value for numeric data.
- ColumnFilter: This allows us to apply a filter to limit the rows in the query result. Filtering here is similar to, but more complicated than, the filtering rules that apply to DataItemTableFilter. Static ColumnFilters can be dynamically overridden and can also be combined with DataItemTableFilters. See the Help section for the ColumnFilter property for more detailed information.