Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Chris on Dec 02, 2009 04:20
open dhtmlx forum
Usage of #stat_total an footer formatting

The xml file below defines the grid I want:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<rows>
<head>
<column hidden="true" width="80" type="ro" sort="na" align="right" format="">AREAGID</column>
<column hidden="false" width="50" type="ro" sort="na" align="center" format="0">Color</column>
<column hidden="false" width="80" type="ro" sort="str" align="left" format="">Name</column>
<column hidden="false" width="80" type="ro" sort="str" align="left" format="">Description</column>
<column hidden="false" width="80" type="ron" sort="int" align="right" format="0,000">Work</column>
<column hidden="false" width="80" type="ron" sort="int" align="right" format="0,000">Sales</column>
<settings>
<colwidth>px</colwidth>
</settings>
</head>
<row id="1">
<cell>8342719467959286662</cell>
<cell><div style='background-color:#a647c0;width:20px;height:20px;'/></cell>
<cell>01</cell>
<cell>Central</cell>
<cell>22255.221</cell>
<cell>276046668.26</cell>
</row>
<row id="2">
<cell>1636956358260613131</cell>
<cell><div style='background-color:#346e69;width:20px;height:20px;'/></cell>
<cell>02</cell>
<cell>Western</cell>
<cell>21685.687</cell>
<cell>274206766.17</cell>
</row>
<row id="3">
<cell>6586154515852534506</cell>
<cell><div style='background-color:#73de16;width:20px;height:20px;'/></cell>
<cell>03</cell>
<cell>Eastern</cell>
<cell>22387.586</cell>
<cell>305880883.95</cell>
</row>
<row id="4">
<cell>458804923949041852</cell>
<cell><div style='background-color:#b1d6f3;width:20px;height:20px;'/></cell>
<cell>05</cell>
<cell>Inside</cell>
<cell>6975.649</cell>
<cell>75869872.16</cell>
</row>
<row id="5">
<cell>6481587117843464876</cell>
<cell><div style='background-color:#f29158;width:20px;height:20px;'/></cell>
<cell>99</cell>
<cell />
<cell>0</cell>
<cell>-19992326.05</cell>
</row>
</rows>

In javascript, after the grid is loaded, I call:

shadingGrid.attachFooter("-,Total,-,-,#stat_total,#stat_total", ["text-align:left;"]);

However, the totals in the footer is empty
Answer posted by dhxSupport on Dec 02, 2009 07:09
Please check if you have attached dhtmlxgrid_filter.js file to your page.
If automatically calculated values were added after grid's initialization, you can force recalculation using the following command: 
  grid.callEvent("onGridReconstructed",[]);