dhtmlxGrid does not display totals in header

Hello,

I’m using the DHTMLX grid (v.2.5 build 91111) with the .Net connector.

Here is the JS code:

var grid = new dhtmlXGridObject(“gridbox”);
grid.setHeader(“Projekt,Standort,Beschreibung,Projektleiter,Aufträge,Rückhaltebetrag,Sicherheitseinbehalt,Summe,abgeschlossen”);

    grid.attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_select_filter,#rspan,#rspan,#rspan,#rspan,#connector_select_filter");
    grid.attachHeader("#rspan,#rspan,#rspan,#rspan,#rspan,#stat_total,#stat_total,#stat_total,#rspan");
    grid.setColTypes("ro,ro,ro,ro,ro,ron,ron,ron,ro");
    grid.setNumberFormat("0,000.00 €", 5, ",", ".");
    grid.setNumberFormat("0,000.00 €", 6, ",", ".");
    grid.setNumberFormat("0,000.00 €", 7, ",", ".");
    grid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector,connector");
    grid.setSkin("dhx_skyblue");
    grid.imgURL = "../Content/dhtmlxGrid/codebase/imgs/";
    grid.enableAutoHeigth(true);
    grid.enableAutoWidth(true);
    grid.setColAlign("left, left, left, left, right, right, right, right, left");
    grid.setInitWidthsP("8, 12, 23, 10, 7, 10, 10, 10, 10");
    grid.enablePaging(true, 20, 15, "pagingToolbar", true);
    grid.setPagingSkin("bricks");
    grid.attachEvent("onRowDblClicked", ClickHandler);
    grid.init();
    grid.load("../Xml/BWProjekte.ashx");
    grid.setSizes();

When loading the page the totals in header are not displayed at all. After filtering the totals are displayed, but sometimes the total is not correct. Also grid loses its a ability to sort with “total” header. When the “total” header is removed, then the sorting works fine.

Please help!

Hello,

#stat_total require all rows to be loaded on the client. It cannot be used with dynamic smart rendering mode.
As a workaround you can calculate total sum of rows on the server side, pass it to the client side with userdata and update grid header label.