The PivotTable band is used for creating cross reports based on static data and also for building aggregate tables. The result of using PivotTable element is a block in a report that contains visual presentation of a described cross table.
There is a special visual editor of a cross table that allows specifying data used for calculation. Scripts can be used for creating rules of calculation. This gives great opportunities for table settings starting from summing up of several fields from the data source and ending with various variants of grouping in the perspectives of required report.
The following bands can be used as containers for PivotTable: Page, DataBand, BandContainer, GroupBand and SideBySide.
More information about using pivot tables.