Crosstab (element)
From JRapid
crosstab is an element, child of panel.
Contents |
Description
The crosstab element includes a crosstab, or cross tabulation, in a panel.
A crosstab groups rows by one property, columns by another, and uses an aggregate function (count, sum etc) of a third property for the table data. The grouping properties are called dimensions.
Usage
<crosstab entity = ENTITY name = NAME title = TITLE panelheight = HEIGHT rows = PROPERTY_LIST columns = PROPERTY_LIST measure = MEASURE />
Example
The CompanyPanel panel includes a companyCrosstab crosstab element.
<panel name="CompanyPanel" title="Company Panel">
<menu/>
<header/>
<column width="100%">
<crosstab entity="Company" name="companyCrosstab" panelheight="100%" title="Companies"/>
</column>
<footer/>
</panel>
<entity crosstab="crosstab" label="Company" menu="People" name="Company" order="name">
<property display="primary" label="Name" name="name"/>
<property label="Address" name="address" type="text"/>
<property dimension="row" display="secondary" entity="City" label="City" name="city"/>
<property dimension="column" display="secondary" label="Active" name="active" type="boolean"/>
<property display="secondary" label="Load Date" name="loadDate" type="date"/>
</entity>
<entity label="City" menu="Places" name="City" order="name">
<property display="primary" label="City" name="name"/>
<property display="secondary" label="Active" name="active" type="boolean"/>
</entity>
The generated panel looks like this.
