New to Kendo UI for jQuery? Download free 30-day trial

PivotGrid resize the width of the row header area

Environment

Product PivotGrid for Progress® Kendo UI®

Description

I am trying to reduce the rowheader width on a pivotgrid because when I get multiple columns the first fixed columns occupies most of the grid space.

How can I change the first columns width?

Solution

The easiest way to accomplish the desired behaviour would be to:

  1. Add a max-width style to the row headers and provide a scroll:

      .k-pivot-rowheaders {
        max-width:200px;
      }
    
      .k-grid.k-alt.k-widget{
        overflow-x: scroll;
      } 
    
  2. For the height, we could use the dataBound event handler to assign it to row headers section so that it is equal to the grid content.
  function onDataBound(e){
     var rowHeaderSection = $(e.sender.rowsHeaderTree.root);
     rowHeaderSection.css({
          height:e.sender.content.height()
     });
  }
    <style>
      .k-pivot-rowheaders {
        max-width:200px;
      }

      .k-grid.k-alt.k-widget{
        overflow-x: scroll;
      } 
    </style>
    <div id="example">
      <div id="pivotgrid"></div>

      <script>
        $(document).ready(function () {
          var pivotgrid = $("#pivotgrid").kendoPivotGrid({
            filterable: true,
            sortable: true,
            columnWidth: 200,
            height: 580,
            dataSource: {
              type: "xmla",
              columns: [{ name: "[Date].[Calendar]", expand: true }, { name: "[Product].[Category]" } ],
              rows: [{ name: "[Geography].[City]" }],
              measures: ["[Measures].[Reseller Freight Cost]"],
              transport: {
                connection: {
                  catalog: "Adventure Works DW 2008R2",
                  cube: "Adventure Works"
                },
                read: "https://demos.telerik.com/olap/msmdpump.dll"
              },
              schema: {
                type: "xmla"
              },
              error: function (e) {
                alert("error: " + kendo.stringify(e.errors[0]));
              }
            },
            dataBound: function(e){
              var rowHeaderSection = $(e.sender.rowsHeaderTree.root);
              rowHeaderSection.css({
                height:e.sender.content.height()
              })
            }
          }).data("kendoPivotGrid");
        });
      </script>
    </div>
In this article
Not finding the help you need? Improve this article