Once you have your basic report structure set up, there are quite a few ways in which you can manipulate their properties:

  • Aggregates - Basic SQL aggregate functions of COUNT, SUM, AVG, MIN, and MAX
  • Previous/Next - Comparisons to records before and after the current record
  • Position - Reference records at a certain position in the result set
  • Ranking - Where a record stands in comparison to other records
  • Percentage - Easy method of calculating percentages
  • Calculations - Basic math involving properties and functions