New to Telerik UI for ASP.NET MVCStart a free 30-day trial

Templates

The Telerik UI PivotGridV2 HtmlHelper for ASP.NET MVC provides built-in templates, which allow you to customize the way the data is displayed in the table.

The templates use the Kendo UI Templates syntax.

The available types of PivotGridV2 templates are:

For a live example, see the PivotGridV2 Templates demo.

Data Cell Template

The data cell template is the template which renders the content of the data cell. By default, it renders the fmtValue formatted value of the data item.

In the data cell template, you can access the following fields:

  • 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.
  • dataItem—The data item itself.
Razor
    @(Html.Kendo().PivotGrid()
        .Name("pivotgrid")
        .ColumnWidth(200)
        .Height(570)
        .DataCellTemplateId("dataCellTemplate")
        // Other configuration.
    )

Column Header Template

The column header template is the template which renders the content of the column header cell. By default, it renders the caption of the tuple member.

In the column header template, you can access the following fields:

  • member—The member of the corresponding column header cell.
  • tuple—The tuple of the corresponding column header cell.
Razor
    @(Html.Kendo().PivotGridV2()
        .Name("pivotgridv2")
        .ColumnWidth(200)
        .Height(570)
        .ColumnHeaderTemplateId("headerTemplate")
        // other configuration settings
    )

Row Header Template

The row header template is the template which renders the content of the row header cell. By default, it renders the caption of the tuple member.

In the row header template, you can access the following fields:

  • member—The member of the corresponding column header cell.
  • tuple—The tuple of the corresponding column header cell.
Razor
    @(Html.Kendo().PivotGridV2()
        .Name("pivotgridv2")
        .ColumnWidth(200)
        .Height(570)
        .RowHeaderTemplateId("headerTemplate")
        // other configuration settings
    )

KPI Status Template

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
  • dataItem—the data item itself
Razor
    @(Html.Kendo().PivotGridV2()
        .Name("pivotgrid")
        .ColumnWidth(200)
        .Height(580)
        .KpiStatusTemplateId("kpiStatusTemplate")
        .DataSource(dataSource => dataSource
        .Xmla()
        .Columns(columns => {
            columns.Add("[Date].[Calendar]").Expand(true);
            columns.Add("[Product].[Category]");
        })
        .Rows(rows => rows.Add("[Geography].[City]"))
        .Measures(measures => measures.Values(v => {
            v.Add().Name("[Measures].[Internet Revenue Status]").Type("status");
        }))
        .Transport(transport => transport
            .Connection(connection => connection
                .Catalog("Adventure Works DW 2008R2")
                .Cube("Adventure Works"))
                .Read("https://demos.telerik.com/olap/msmdpump.dll")
            )
        )
    )

KPI Trend Template

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
  • dataItem—the data item itself
Razor
    @(Html.Kendo().PivotGridV2()
        .Name("pivotgrid")
        .ColumnWidth(200)
        .Height(580)
        .KpiTrendTemplateId("kpiTrendTemplate")
        .DataSource(dataSource => dataSource
        .Xmla()
        .Columns(columns => {
            columns.Add("[Date].[Calendar]").Expand(true);
            columns.Add("[Product].[Category]");
        })
        .Rows(rows => rows.Add("[Geography].[City]"))
        .Measures(measures => measures.Values(v => {
            v.Add().Name("[Measures].[Internet Revenue Trend]").Type("trend");
        }))
        .Transport(transport => transport
            .Connection(connection => connection
                .Catalog("Adventure Works DW 2008R2")
                .Cube("Adventure Works"))
                .Read("https://demos.telerik.com/olap/msmdpump.dll")
            )
        )
    )

See Also