How to Show Columns Total with Client Side

575

ahmed posted over 16 years ago

Hi all

can anyone help me if thiers a way to get the Totals of Columns in the Client Side rather than set an Empty CellUpdate EventHnadler

i need the Total to be Calculated in Server Side rather than Client Side

and Thanks Alot

334

Duan Brito posted over 16 years ago in reply to ahmed

I update grid's footer using javascript and works perfectly!

I use this function below:
function total_footer_uwg(gridID)
{
var rows = igtbl_getGridById(gridID).Rows;
var vlr_total = 0;
for (var i = 0; i < rows.length; i++)
{

vlr_unit = rows.getRow(i).getCell(indexofthecolumn).getValue();
if (vlr_unit!=null)
{
vlr_unit = vlr_unit;if (!isNaN(vlr_unit))
vlr_total += parseFloat(vlr_unit);

}

}
if (rows.getRow(0)!=null)rows.getRow(0).getCell(0).Element.parentNode.parentNode.nextSibling.childNodes[0].childNodes[indexofthecolumn+1].innerHTML = "<nobr>" + (vlr_total) + "</nobr>";
}

After just call the function!
Cancel
Reply

Verify Answer

Cancel
45049

[Infragistics] Vince McDonald posted over 16 years ago in reply to ahmed

WebCalcManager has no client-side presence, so it can't do any recalculation except on the server.

Likewise, summaries are only updated on the server.

As a workaround, I suggest that you wrap your WebGrid in either a WARP or an UpdatePanel. You'll still perform the calculations on the server, but it will be done via AJAX rather than a full-page postback.
Cancel
Reply

Verify Answer

Cancel
575

ahmed posted over 16 years ago in reply to [Infragistics] Ivan Baev

Thanks for your reply ... the samples is great .. but what if i need to calculate at Client Side and not make the Post back i have in My grid 2 Summaries
1-for the Columns and i use the Column.total and sum funcation and show at summary row
2-for the Row Total and use ultraCalcManager to make the Formula of the sum
actually both of the two functions make post back and need empty UpdateCell Event handler .. i need to make both in client side without any post back
Cancel
Reply

Verify Answer

Cancel
7694

[Infragistics] Ivan Baev posted over 16 years ago

Normal 0 21 false false false BG X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}
Hello,

Please take a look at the samples:

http://samples.infragistics.com/2008.2/webfeaturebrowser/default.htm

Grid->Grid Summaries

Grid->Balance Sheet

Grid->Basic Math

Grid->Dental Products Grid

Grid-> Calculator

Hope this samples help.
Cancel
Reply

Verify Answer

Cancel