Crosstab (element)

From JRapid

Jump to: navigation, search

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.

Panel with crosstab example

See also

Personal tools