<kendo:pivotGrid>

A JSP wrapper for Kendo UI PivotGrid.

Configuration Attributes

autoBind boolean

If set to false the widget will not bind to the data source during initialization. In this case data binding will occur when the change event of the data source is fired. By default the widget will bind to the data source specified in the configuration.

Example

<kendo:pivotGrid autoBind="autoBind">
</kendo:pivotGrid>

columnHeaderTemplate java.lang.String

The template which renders the content of the column header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding column header cell or tuple - the tuple of the corresponding column header cell. For information about the tuple structure check this link.

Example

<kendo:pivotGrid columnHeaderTemplate="columnHeaderTemplate">
</kendo:pivotGrid>

columnWidth float

The width of the table columns. Value is treated as pixels.

Example

<kendo:pivotGrid columnWidth="columnWidth">
</kendo:pivotGrid>

dataCellTemplate java.lang.String

The template which renders the content of the data cell. By default renders the formatted value (fmtValue) of the data item.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.

Example

<kendo:pivotGrid dataCellTemplate="dataCellTemplate">
</kendo:pivotGrid>

filterable boolean

If set to true the user will be able to filter by using the field menu.

Example

<kendo:pivotGrid filterable="filterable">
</kendo:pivotGrid>

height java.lang.Object

The height of the PivotGrid. Numeric values are treated as pixels.

Example

<kendo:pivotGrid height="height">
</kendo:pivotGrid>

kpiStatusTemplate java.lang.String

The template which renders the content of the KPI Status value. By default renders "open", "hold" and "denied" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.

Example

<kendo:pivotGrid kpiStatusTemplate="kpiStatusTemplate">
</kendo:pivotGrid>

kpiTrendTemplate java.lang.String

The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.The fields which can be used in the template are: columnTuple - the tuple of the corresponding column header cell; rowTuple - the tuple of the corresponding row header cell; measure - the value of the data cell measure or dataItem - the data item itself. For information about the tuple structure check this link. About the data item structure review this help topic.

Example

<kendo:pivotGrid kpiTrendTemplate="kpiTrendTemplate">
</kendo:pivotGrid>

reorderable boolean

If set to false the user will not be able to add/close/reorder current fields for columns/rows/measures.

Example

<kendo:pivotGrid reorderable="reorderable">
</kendo:pivotGrid>

rowHeaderTemplate java.lang.String

The template which renders the content of the row header cell. By default it renders the caption of the tuple member.The fields which can be used in the template are: member - the member of the corresponding row header cell or tuple - the tuple of the corresponding row header cell. For information about the tuple structure check this link.

Example

<kendo:pivotGrid rowHeaderTemplate="rowHeaderTemplate">
</kendo:pivotGrid>

sortable boolean

If set to true the user could sort the pivotgrid by clicking the dimension fields. By default sorting is disabled.Can be set to a JavaScript object which represents the sorting configuration. Further configuration is available via kendo:pivotGrid-sortable.

Example

<kendo:pivotGrid sortable="sortable">
</kendo:pivotGrid>

Configuration JSP Tags

kendo:pivotGrid-excel

Configures the Kendo UI PivotGrid Excel export settings.

More documentation is available at kendo:pivotGrid-excel.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-excel></kendo:pivotGrid-excel>
</kendo:pivotGrid>

kendo:pivotGrid-messages

The text messages displayed in the fields sections.

More documentation is available at kendo:pivotGrid-messages.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-messages></kendo:pivotGrid-messages>
</kendo:pivotGrid>

kendo:pivotGrid-pdf

Configures the Kendo UI PivotGrid PDF export settings.

More documentation is available at kendo:pivotGrid-pdf.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-pdf></kendo:pivotGrid-pdf>
</kendo:pivotGrid>

kendo:pivotGrid-sortable

If set to true the user could sort the pivotgrid by clicking the dimension fields. By default sorting is disabled.Can be set to a JavaScript object which represents the sorting configuration.

More documentation is available at kendo:pivotGrid-sortable.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-sortable></kendo:pivotGrid-sortable>
</kendo:pivotGrid>

Event Attributes

dataBinding String

Fired before the widget binds to its data source.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the dataBinding event documentation.

Example

<kendo:pivotGrid dataBinding="handle_dataBinding">
</kendo:pivotGrid>
<script>
    function handle_dataBinding(e) {
        // Code to handle the dataBinding event.
    }
</script>

dataBound String

Fired after the widget is bound to the data from its data source.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the dataBound event documentation.

Example

<kendo:pivotGrid dataBound="handle_dataBound">
</kendo:pivotGrid>
<script>
    function handle_dataBound(e) {
        // Code to handle the dataBound event.
    }
</script>

expandMember String

Fired before column or row field is expanded.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the expandMember event documentation.

Example

<kendo:pivotGrid expandMember="handle_expandMember">
</kendo:pivotGrid>
<script>
    function handle_expandMember(e) {
        // Code to handle the expandMember event.
    }
</script>

collapseMember String

Fired before column or row field is collapsed.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the collapseMember event documentation.

Example

<kendo:pivotGrid collapseMember="handle_collapseMember">
</kendo:pivotGrid>
<script>
    function handle_collapseMember(e) {
        // Code to handle the collapseMember event.
    }
</script>

excelExport String

Fired when saveAsExcel method is called.

For additional information check the excelExport event documentation.

Example

<kendo:pivotGrid excelExport="handle_excelExport">
</kendo:pivotGrid>
<script>
    function handle_excelExport(e) {
        // Code to handle the excelExport event.
    }
</script>

pdfExport String

Fired when the user clicks the "Export to PDF" toolbar button.

For additional information check the pdfExport event documentation.

Example

<kendo:pivotGrid pdfExport="handle_pdfExport">
</kendo:pivotGrid>
<script>
    function handle_pdfExport(e) {
        // Code to handle the pdfExport event.
    }
</script>

Event Tags

kendo:pivotGrid-dataBinding

Fired before the widget binds to its data source.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the dataBinding event documentation.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-dataBinding>
        <script>
            function(e) {
                // Code to handle the dataBinding event.
            }
        </script>
    </kendo:pivotGrid-dataBinding>
</kendo:pivotGrid>

kendo:pivotGrid-dataBound

Fired after the widget is bound to the data from its data source.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the dataBound event documentation.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-dataBound>
        <script>
            function(e) {
                // Code to handle the dataBound event.
            }
        </script>
    </kendo:pivotGrid-dataBound>
</kendo:pivotGrid>

kendo:pivotGrid-expandMember

Fired before column or row field is expanded.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the expandMember event documentation.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-expandMember>
        <script>
            function(e) {
                // Code to handle the expandMember event.
            }
        </script>
    </kendo:pivotGrid-expandMember>
</kendo:pivotGrid>

kendo:pivotGrid-collapseMember

Fired before column or row field is collapsed.The event handler function context (available via the this keyword) will be set to the widget instance.

For additional information check the collapseMember event documentation.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-collapseMember>
        <script>
            function(e) {
                // Code to handle the collapseMember event.
            }
        </script>
    </kendo:pivotGrid-collapseMember>
</kendo:pivotGrid>

kendo:pivotGrid-excelExport

Fired when saveAsExcel method is called.

For additional information check the excelExport event documentation.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-excelExport>
        <script>
            function(e) {
                // Code to handle the excelExport event.
            }
        </script>
    </kendo:pivotGrid-excelExport>
</kendo:pivotGrid>

kendo:pivotGrid-pdfExport

Fired when the user clicks the "Export to PDF" toolbar button.

For additional information check the pdfExport event documentation.

Example

<kendo:pivotGrid>
    <kendo:pivotGrid-pdfExport>
        <script>
            function(e) {
                // Code to handle the pdfExport event.
            }
        </script>
    </kendo:pivotGrid-pdfExport>
</kendo:pivotGrid>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy