PIVOT_TABLE marker
PIVOT_TABLE marker is used for output data in the form of summary table. Output area is divided into nine parts:
HEADERS |
DATA |
TOTAL |
||
TOP_LEFT_CORNER |
COLUMN_HEADER[..M] |
TOP_RIGHT_CORNER |
||
SERIES_HEADER[…N] |
{PIVOT_DATA| |
PIVOT_CELL_NO_DATA} |
[..M,..N] |
SERIES_TOTAL[…N] |
BOTTOM_LEFT_CORNER |
COLUMN_TOTAL[..M] |
BOTTOM_RIGHT_CORNER |
||
где N –quantity of series, а М - quantity of table columns
Description
<!PIVOT_TABLE src="source" [suid="suid"] [headers="number"] [data="number"] [totals="number"] [inline="true|false"]!> |
||
<!PIVOT_SETTINGS [cond="bool expression"]!> |
||
<!SERIES_GROUP clmn="series_grouping" [order="ASC|DESC"]!> |
||
<!COLUMN_GROUP clmn="column_grouping" [order="ASC|DESC"]!> |
||
[<!PIVOT_EXTRA [insert="false|true"] [copyColumnWidths="true|false"]!>] |
||
<!\PIVOT_SETTINGS!>[..n] |
||
[<!PIVOT_NO_DATA [cond="bool expression"]!> |
||
<static print area> |
||
<!\PIVOT_NO_DATA!>][..n] |
||
[<!TOP_LEFT_CORNER [cond="bool expression"]!> |
||
<static print area> |
||
<!\TOP_LEFT_CORNER!>][..n] |
|
|
[<!SERIES_HEADER [cond="bool expression"]!> |
|
|
<series group cell print area> |
||
<!\SERIES_HEADER!>][..n] |
|
|
[<!BOTTOM_LEFT_CORNER [cond="bool expression"]!> |
|
|
<static print area> |
||
<!\BOTTOM_LEFT_CORNER!>][..n] |
|
|
[<!COLUMN_HEADER [cond="bool expression"]!> |
|
|
<column group cell print area> |
||
<!\COLUMN_HEADER!>][..n] |
|
|
<!PIVOT_DATA [cond="bool expression"]!> |
|
|
<data cell print area> |
||
<!\PIVOT_DATA!>[..n] |
|
|
[<!PIVOT_CELL_NO_DATA [cond="bool expression"]!> |
|
|
<data cell print area> |
||
<!\PIVOT_CELL_NO_DATA!>][..n] |
|
|
[<!COLUMN_TOTAL [cond="bool expression"]!> |
|
|
<column group cell print area> |
||
<!\COLUMN_TOTAL!>][..n] |
|
|
[<!TOP_RIGHT_CORNER [cond="bool expression"]!> |
|
|
<static print area> |
||
<!\TOP_RIGHT_CORNER!>][..n] |
|
|
[<!SERIES_TOTAL [cond="bool expression"]!> |
|
|
<series group cell print area> |
||
<!\SERIES_TOTAL!>][..n] |
|
|
<!BOTTOM_RIGHT_CORNER [cond="bool expression"]!> |
|
|
<static print area> |
||
<!\BOTTOM_RIGHT_CORNER!>][..n] |
|
|
<!\PIVOT_TABLE!> |
|
|
<static print area> ::= [<!CELL..!>|<!FORMULA..!>|empty or static text]
<series group cell print area> ::=[<!CELL..!>|<!FORMULA..!>| <pivot cell>|<pivot formula>|empty or static text]
<column group cell print area> ::=[<!CELL..!>|<!FORMULA..!>| <pivot cell>|<pivot formula>|empty or static text]
<data cell print area> ::= [<!CELL..!>|<!FORMULA..!>| <pivot cell>|<pivot formula>|empty or static text]
<pivot cell> ::= <!PIVOT_CELL {clmn="column"| expr="expression"}[ type="<print type>"][ uid="uid"][ hide="true|false"]
[ style="style_name"[ style_args="arg1,arg2,…,argN"]][ comm="comm_name"[ comm_args="arg1,arg2,…,argN"]]!>
<pivot formula> ::= <!GROUP_FORMULA text="formula" [ uid="uid"][ hide="true|false"]
[ style="style_name"[ style_args="arg1,arg2,…,argN"]][ comm="comm_name"[ comm_args="arg1,arg2,…,argN"]]!>
PIVOT_TABLE – the main marker describing the summary table.
source
Data source name, which is the same as report name or subreport name from reportConfiguration.config file
suid
Unique name is used with PlaceFor marker . It`s unique within the template.
inline
Output structure type. True – output structure where it was declared, False – output structure by
headers="number"
Quantity of columns used for HEADERS series area and the highest left and lower corner of the table. By default is 1.
data="number"
Quantity of columns used for DATA area and и output column table and cell data table. By default is 1.
totals="number"
Quantity of columns used for TOTALS area output series and highest right and lower corner of the table. By default is 1.
Cell description in print area is considered in that area, where the describing marker print area is. In examples areas are marked out the same way (in this case DATA area is an active, active cells are marked red frame out):
HEADERS |
DATA |
TOTAL |
|||
<!PIVOT_DATA!> |
|
|
|
|
|
<!\PIVOT_DATA!> |
|
|
|
|
|
Active area mark columns, which cells will be the part of output report. Headers of area indicated in template for comfort only and ignored while the system works. Area beginning is calculated by columns, from PIVOT_TABLE column marker. Every area has quantity of columns, indicated in attributes of PIVOT_TABLE marker. Area order – HEADERS, DATA, TOTAL.
PIVOT_SETTINGS –setting group data table marker.
SERIES_GROUP – grouping series summary table marker. Shows the data source column, which group table series. It is a binding marker.
clmn="series_grouping"
Grouping series table column
order="ASC|DESC"
Sorting series order. By default sorting is absent.
COLUMN_GROUP – grouping columns summary table marker. Shows the data source column, which group table column. It is a binding marker.
clmn="column_grouping"
Grouping table source column
order="ASC|DESC"
Sorting columns order. By default sorting is absent.
PIVOT_EXTRA – extra properties summary table marker.
bindType="NONE|INSERT"
Output structure type. NONE – without insert series (changing cells style only), INSERT – with insert series.
copyColumnWeights="true|false"
Output structure type. Use column weight of the sheet, or copy column weight.
PIVOT_NO_DATA – marker describing print report without data.
HEADERS markers area
TOP_LEFT_CORNER – top left corner marker.
SERIES_HEADER – header output summary table series marker.
BOTTOM_LEFT_CORNER – bottom left corner marker.
DATA markers area
COLUMN_HEADER – header output summary table columns marker.
PIVOT_DATA – summary table data cells output marker.
PILOT_CELL_NO_DATA – cells output, if the data is absent.
COLUMN_TOTAL – total summary table columns output marker.
TOTALS markers area
TOP_RIGHT_CORNER – top right corner marker.
SERIES_HEADER – total summary table series output marker
BOTTOM_RIGHT_CORNER – bottom right corner marker.
cond=" bool expression"
Condition (conditional expression) proposes to use marker. (In details about expressions see Expression language).
Print areas
All print areas may contain any quantity of series. Column quantity of sheet is constant and equal the column quantity of sheet area, describing marker belong to. ). In description you can see what the cell print area may consist of.
<static print area>
Print area, which doesn`t propose to use data and named print areas (for formulas) group print.
<!CELL..!> - CELL. Don`t use this marker with print type attribute values: DOWN_INSERT, RIGHT_INSERT. While using it with DOWN, RIGHT values spy on marker output not overstep the limits of print area.
<!FORMULA..!> - Formula.
<series group cell print area> ::=[<!CELL..!>|<!FORMULA..!>| <pivot cell>|<pivot formula>|empty or static text]
<column group cell print area> ::=[<!CELL..!>|<!FORMULA..!>| <pivot cell>|<pivot formula>|empty or static text]
<data cell print area> ::= [<!CELL..!>|<!FORMULA..!>| <pivot cell>|<pivot formula>|empty or static text]
< series group cell print area>
Print area total marker. It`s possible to use first series data for output group print and named output areas group.
< column group cell print area>
Column group cell print area total marker. It`s possible to use first series data for output print and named area column groups.
<data cell print area>
Data cell print area. It`s possible to use current series data and named output current series areas
PIVOT_CELL – group data marker. It`s the main group nesting marker. It is intended for group data output.
clmn
Data source column name. Use this attribute with COLUMN output data type
expr
Calculated expression for output. Use this attribute with EXPRESSION output data type. (In details about expressions see Expression language).
print type
Output data type. There are some values:
COLUMN
Output column value from the first series of data source (for HEADER and FOOTER) or for current series (for DATA). Value is by default
EXPRESSION
Output expression result, indicated in expr attribute to the cell
<print type>::= COLUMN|EXPRESSION
PIVOT_FORMULA – group data marker is intended for putting calculated formula on group data in.
text="formula"
Calculated formula. Use the global uid and uid of group available area only. (In details see Formula creation).
Common attributes for PIVOT_CELL and PIVOT_FORMULA
uid
Unique cell (row) name, output by marker. (In details see Unique cell names).
hide="true|false"
Hide field. Data will be output in field, but color type will be the same as color background
style="style_name"
Style cell name. (In details see STYLE marker)
style_args="arg1,arg2,…,argN"
Arguments which are used for determining cell style. Argument may be constant or expression (In details about expressions see Expression language).
comm="comment_name"
Cell comment name. (In details see COMMENT marker)
comm_args="arg1,arg2,…,argN"
Arguments which are used for determining and/or calculating cell comment. Argument may be constant or expression (In details about expressions see Expression language).
Examples
PivotTable.xlsx, PivotTable(colored).xlsx
Created with the Personal Edition of HelpNDoc: Produce electronic books easily