GROUP_SECTION marker
Structured GROUP_SECTION marker is intended for grouping of data binding.
Description
<!GROUP_SECTION src="source" [suid="suid"] [inline="true|false"]!> |
||||||||
[<!GROUP_SETTINGS [cond=" bool expression"]!> |
||||||||
[<!EXTRA_HEIGHT value="extra height" [measure="p|in|mm"]!>] |
|
|
|
|||||
[<!GROUP_NO_DATA_SETTINGS[printPageHeader="true|false"] [printPageFooter="true|false"]!>] |
||||||||
[<!GROUP_EXTRA [insert="false|true"] [copyColumnWidths="true|false"]!>] |
||||||||
<!\GROUP_SETTINGS!> [..n]] |
|
|
|
|
|
|
||
[<!GROUP_NO_DATA[cond=" bool expression"]!> |
||||||||
<static print area> |
||||||||
<!\GROUP_NO_DATA!> [..n]] |
|
|
|
|
|
|
||
[<!PAGE_HEADER[cond=" bool expression"]!> |
||||||||
<static print area> |
||||||||
<!\PAGE_HEADER!> [..n]] |
|
|
|
|
|
|
|
|
[<!HEADER[cond=" bool expression"]!> |
|
|
|
|
|
|
|
|
<section cell print area> |
||||||||
<!\HEADER!> [..n]] |
|
|
|
|
|
|
|
|
<group or data> |
||||||||
[<!FOOTER[cond=" bool expression"]!> |
|
|
|
|
|
|
|
|
<section cell print area> |
||||||||
<!\FOOTER!> [..n]] |
|
|
|
|
|
|
|
|
[<!EMPTY_SERIES [cond=" bool expression"]!> |
||||||||
<static print area> |
||||||||
<!\EMPTY_SERIES!> [..n]] |
|
|
|
|
|
|
|
|
[<!PAGE_FOOTER [cond=" bool expression"]!> |
||||||||
<static print area> |
||||||||
<!\PAGE_FOOTER!> [..n]] |
|
|
|
|
|
|
|
|
<!\GROUP_SECTION!> |
|
|
|
|
|
|
|
|
<group or data> ::= |
||||||||
{<!GROUP clmn="column" [order="ASC|DESC"]!> |
|
|
|
|
||||
[<!HEADER [cond=" bool expression"]!> |
|
|
|
|
|
|
|
|
<group cell print area> |
||||||||
<!\HEADER!> [..n]] |
|
|
|
|
|
|
|
|
<group or data> |
||||||||
[<!FOOTER [cond=" bool expression"]!> |
|
|
|
|
|
|
|
|
<group cell print area> |
||||||||
<!\FOOTER!> [..n]] |
|
|
|
|
|
|
|
|
<!\GROUP!>} |
|
|
|
|
|
|
|
|
| |
||||||||
{<!DATA [cond=" bool expression"]!> |
||||||||
<data cell print area> |
||||||||
<!\DATA!>[..n]} |
|
|
|
|
|
|
|
|
<static print area> ::= [<!CELL..!>|<!FORMULA..!>|empty or static text]
<section cell print area> ::=[<!REMOVE..!>| <!CELL..!>|<!FORMULA..!>|<group formula>|empty or static text]
<group cell print area> ::= [<!REMOVE..!>| <!CELL..!>|<!FORMULA..!>| <group cell>|<group formula>|empty or static text]
<data cell print area> ::= [<!REMOVE..!>| <!CELL..!>|<!FORMULA..!>| <group cell>|<group formula>|empty or static text]
<group cell> ::= <!GROUP_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"]]!>
<group 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"]]!>
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.
GROUP_SETTINGS – settings of grouping of data structure marker.
EXTRA_HEIGHT – extra height print area marker. If the page margins are too large (there is empty area at the end of page) you can move apart print area on the page.
extra height
Extension value of page area
measure
Extension value of area units
- p(point) – Excel units
- in(inch) – inches
- mm – millimeters
GROUP_NO_DATA_SETTINGS – controlling report without data behavior marker.
printPageHeader
Output page header.
printPageFooter
Output page footer .
GROUP_NO_DATA – describing output report without data marker.
GROUP_EXTRA – complementary features of grouping of structure marker.
bindType="NONE|INSERT"
Output structure type. NONE – without inset series (changing cells style only), INSERT – with inset series.
copyColumnWeights="true|false"
Output structure type. Use column weight of the sheet, or copy column weight.
PAGE_HEADER – page header marker.
HEADER –header report marker, which appears on the first page only.
FOOTER – total report marker, which appears at the end of the last page.
EMPTY_SERIES – describes empty series. Use with PAGE_FOOTER marker. Output area marker must consist of one series only. This marker doesn`t depend on height series changes.
PAGE_FOOTER – page footer marker. Use with EMPTY_SERIES marker only.
cond=" bool expression"
Condition (conditional expression) proposes to use marker. (In details about expressions see Expression language).
GROUP – description of grouping of data marker.
column
Data source column name, which will be used in grouping.
order
Note sorting type inside group. If sorting isn`t indicated, then notes will be output in order the same as in data source.
HEADER –header group marker.
FOOTER – total group marker.
DATA – output the main data 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 (except EMPTY_SERIES marker area, always one series only). 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.
<section cell print area>
Print area total marker. It`s possible to use first series data for output group print and named output areas group
<group cell print area>
Total group marker print area. It`s possible to use first series data of this group and named output <data cell print area> and subordinated <group cell print area>
<data cell print area>
Data marker print area. . It`s possible to use current series data and named output current series areas
GROUP_CELL – group data marker. It`s the main group nesting marker. It is intended for group data otput.
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
GROUP_FORMULA – group data marker is intended for putting calculated formula on group data in.
formula
Calculated formula. Use the global uid and uid of group available area only. (In details see Formula creation).
Общие атрибуты для GROUP_CELL и GROUP_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
Grouping.xlsx, Grouping(colored).xlsx
Created with the Personal Edition of HelpNDoc: Free iPhone documentation generator