Group by column that is not in grid, but have title

[Jaanus]

How can I set a grouping that is not in the grid, but have a nice title.

https://dojo.telerik.com/OcUFuLom

 

I want group by school id, but that the grouping header have school name.

 

So instead of school.id: 33, I want there to be School : Test

[Jaanus]

One option is to use the school.id as column and set template and group header template, but then excel export shows IDs, instead of names.

https://dojo.telerik.com/uLUDUteM

[Georgi]

Hi Jaanus,

A possible solution to apply the format to the exported file is modify the value of the cell within the excelExport event handler.

e.g.

   excelExport: function(e) {
  var sheet = e.workbook.sheets[0];

  for (var i = 1; i < sheet.rows.length; i++) {
    var row = sheet.rows[i];
    if(row.type ==="data"){
      row.cells[2].value = getById( row.cells[2].value)

    }
  }
}

Below you will find a modified version of the provided sample:

• https://dojo.telerik.com/UjeKIZiD

Regards,
Georgi
Progress Telerik

[Jaanus]

How would it work when columns are reorderable?

[Georgi]

Hello Jaanus,

In this case I can suggest you to find the index of the column using the field name.

e.g.

var index;

this.columns.forEach(function (col, i) {
  if (col.field == 'school.id') {
    index = i;
  }
})

    row.cells[index].value = getById(row.cells[index].value)

Below you will find a modified version of the sample:

• https://dojo.telerik.com/ExiqiVex

Regards,
Georgi
Progress Telerik