Start Building Professional
Web Apps Today

how to avoid rendering when calculating a total for checked rows

Hi

I am currently using static smart rendering but considering getting professional edition so i can switch to paging. My grid has about 2000 rows.

I need to calculate a total for a column in a grid to display it in my custom footer. I am doing it this way.

var size = 0;
for(var k=0;k<mygrid.getRowsNum();k++){
     size += mygrid.cells2(k,5).getValue()*1;
}

However first time it takes really long because all the rows are rendered. Is there a way to avoid rendering in this case ?

thanks

Victoria

a) you can use private data access method
        size += mygrid._get_cell_value(mygrid.rowsBuffer[k],5)*1;

b) grid has built-in data counters
http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/08_filtering/03_pro_filter_num.html