The following screenshot is a Column Property screen showing the Quantity Column for our simple Query (the MethodType and Method properties are in use):

The properties shown in the preceding for a Query Column control are as follows:

• MethodType: This controls the interpretation of the following Method property. This can be Undefined/None, Date, or Totals.
• Method: This is dependent on the value of the MethodType property:
  • If MethodType = Date, then Method assumes that the Column accesses a date value. The value of Method can be Day, Month, or Year and the Query result for the Column will be the extracted day, month, or year from the source date data.
  • If MethodType = Totals, then Method can be Sum, Count, Avg, Min, or Max. 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 ColumnFilters property for more detailed information.