This is a normal tabular report (don't get confused by its name)
The layout of a flat table looks like:
Column 1Column 2column 3column 4column 5
data 11
data 12
data 13
data 14
data 15
data 21
data 22
data 23
data 24
data 25
data 31
data 32
data 33
data 34
data 35
The mandatory settings of a flat table are:
data columns
table input
The optional settings are:
group columns
sorting values
showing data
showing totals
showing grand total
Usually the flat table is used as a component of a report:
{@code
FlatTable flatTable = new FlatTableBuilder()
.input(new TextInput(".
interface |
PivotTable
Pivot Table interface
A pivot table has a layout like:
|
| Males
| Females
| Region
| Country
| Elephants
| Rhinos
| Squirrels
| Elephants
| Rhinos
| Squirrels
| North
| Sweden
| 1000
| 10
| 4
| 1
| 0
| 0
|
| Norway
| 0
| 100
| 0
| 0
| 0
| 0
| South
| Italy
| 2000
| 0
| 0
| 0
| 0
| 0
| East
| Romania
| 0
| 0
| 0
| 0
| 200
| 0
| West
| France
| 300
| 0
| 3000
| 30
| 0
| 0
The pivot table accepts all settings of a FlatTable (input, data columns, group columns, sorting values) and it introduces
two more mandatory settings: .
|
Copyright © 2006–2015. All rights reserved.
|