http://www.intersoftsolutions.com/Community/Lounge/Group-By-Grand-Total/http://www.intersoftsolutions.comenCopyright 2002 - 2015 Intersoft Solutions Corp. All rights reserved.60http://www.intersoftsolutions.com/Community/Lounge/Group-By-Grand-Total/Thu, 28 Apr 2011 08:05:11 GMTlili<p>Hi,</p> <p> </p> <p>WebGrid has an option to show grandtotal of each group and total of all group. Here, I attach the simple sample for you. Or you could see in our WebGrid sample called CustomAggregation, ColumnTotal, and GroupRowInfoFormat for reference.</p> <p>Hope it helps.</p> <p> </p> <p>Regards, </p> <p>Lili Khiung</p>http://www.intersoftsolutions.com/Community/Lounge/Group-By-Grand-Total/Tue, 26 Apr 2011 23:44:19 GMTkhanhnguyen<div class="GroupContent MessageContent" id="MessageBody"> <p>Hi Intersoft,</p> <p>I have a webgrid with1 columns in group by fields. And I want to add arow to show grand total of all groupsin mygrid but I can'tfind a way to add a custom rowin client javascript. Do you know anyway to do that or does webgrid have an option to show grand total of all group by data?</p> <p>Thanks and Regards</p> <p>Khanh Nguyen<br /></p></div><xml id="wtbInquiryAction_x"><!--[CDATA[<WebToolBar Style1="" Width="100%" Height="25px" MergeToolBar="True" MergeToolBarParentID="tlbContainer" NewIsFloat="Default" IsFloat="Default" HeaderCaptionStyle="W2ADBHC" CommandDisabledStyle="W27ICE4" NewDockingArea="NotSet" NewDockingRow="0" SeparatorStyle="W2HDG0A" HandleStyle="W3EBE90" BodyStyle="WFJHFE" OptionStyle="W2D6HEG" Caption="wtbInquiryAction" AllowCustomize="No" AllowExpandCollapse="No" DockingArea="NotSet" DockingRow="0" IntegratedTo="None" CommandDisableFontStyle="W295GGI" CommandSize="" MergeCommandID="cmdMessageContainer" ServerUniqueID="wtbInquiryAction" UseWebResourcesForScript="True" UseWebResourcesForClient="True" ViewStateStorage="None" xmlInputHiddenUniqueID="wtbInquiryAction_h"><HeaderButtonStyle Normal="W2CHFAB" Over="WC41CH" Active="W2CFF3G" /><CommandStyle Normal="W15FJBH" Over="WHBJDJ" Active="W15HCGA" /><CommandFontStyle Normal="W25E7EH" Over="W1GIE69" Active="W25FGGC" /><Commands><ToolCommand Pushed="False" AutoCheck="True" Checked="False" Name="cmdSolved" Visible="True" IsEnabled="True" Image="../Images/DocApproved-16.gif" Text="Mark as Solved" Category="wtbInquiryAction" AutoPostBack="Yes" DisplayMode="TextAndImage" MergeCommandID=""><Items /></ToolCommand><ToolCommand Pushed="False" AutoCheck="True" Checked="False" Name="cmdUnSolved" Visible="True" IsEnabled="True" Image="../Images/DocRejected-16.gif" Text="Mark as Unsolved" Category="wtbInquiryAction" AutoPostBack="Yes" DisplayMode="TextAndImage" MergeCommandID=""><Items /></ToolCommand><ToolCommand Pushed="False" AutoCheck="True" Checked="False" Name="cmdReOpen" Visible="False" IsEnabled="True" Image="" Text="Reopen Incident" Category="wtbInquiryAction" AutoPostBack="Yes" MergeCommandID=""><Items /></ToolCommand><ToolCommand Pushed="False" Type="Separator" AutoCheck="True" Checked="False" Name="Sep0" Visible="True" IsEnabled="True" Image="" Text="" Category="wtbInquiryAction" MergeCommandID=""><Items /></ToolCommand></Commands><ToggleGroups /><HandleStyle BackColor="#C4C4AD" /><BodyStyle BackColor="#ECE7E0" /><OptionStyle BackColor="#C4C4AD" /></WebToolBar>]]--></xml> <table cellspacing="0" cellpadding="0" border="0" id="wtbInquiryAction_f" style="overflow: hidden; width: 100%; display: none; float: left; height: 25px;"> <tbody> <tr> <td> <table cellspacing="0" cellpadding="0" border="0" title="" class="wtbInquiryAction_if" id="wtbInquiryAction_if" style="z-index: 9997; background-color: transparent; width: 100%; float: left; table-layout: fixed; height: 100%;"> <tbody style="display: none;"> <tr> <td></td></tr></tbody> <tbody id="wtbInquiryAction_f_Horizontal"> <tr> <td> <table cellspacing="0" cellpadding="0" border="0" style="width: 100%;"> <tbody> <tr id="wtbInquiryAction_fh" style="background-color: white; display: none;"> <td class="W2ADBHC">wtbInquiryAction</td> <td onclick="ShowOptionWindow(&quot;wtbInquiryAction&quot;)" class="W2CHFAB"><span style="font-family: webdings;">6</span></td> <td onclick="HideFloatingToolBar(&quot;wtbInquiryAction&quot;)" class="W2CHFAB"><span style="font-family: webdings;">r</span></td></tr></tbody></table></td></tr> <tr> <td> <table cellspacing="0" cellpadding="0" border="0" style="width: 100%; height: 21px;"> <tbody> <tr> <td id="wtbInquiryAction_tbh_Horizontal" style="overflow: hidden; width: 8px;"> <div style="width: 8px; height: 25px; cursor: move;"> <div handlebgcolor="true" style="overflow: hidden; background-color: rgb(196, 196, 173); width: 5px; float: left; height: 25px;"> </div></div></td> <td style="width: 100%;"> <div bodybgcolor="true" style="overflow: hidden; background-color: rgb(236, 231, 224); width: 100%; height: 25px;"> <table cellspacing="0" cellpadding="0" border="0" style="overflow: hidden; width: 100%; table-layout: fixed; height: 100%;"> <tbody> <tr> <td> </td></tr> <tr> <td style="width: 100%; height: 100%;"> <table cellspacing="0" cellpadding="0" border="0" id="wtbInquiryAction_tbic_Horizontal" style="overflow: hidden; width: 100%; height: 100%;"> <tbody> <tr> <td type="m" style="width: 2px;"> </td> <td type="m" style="width: 2px;"> </td> <td type="m" style="width: 2px; display: none;"> </td> <td type="m" style="width: 2px;"> </td> <td valign="center" align="middle" class="W2HDG0A" id="wtbInquiryAction_Sep0_tbitm" /> <td style="width: 100%; height: 100%;" /></tr></tbody></table></td></tr> <tr> <td> </td></tr></tbody></table></div></td></tr></tbody></table></td></tr></tbody> <tbody id="wtbInquiryAction_f_Vertical" style="display: none;"> <tr> <td> <table cellspacing="0" cellpadding="0" border="0" style="width: 21px; height: 100%;"> <tbody> <tr> <td id="wtbInquiryAction_tbh_Vertical" style="overflow: hidden; height: 8px;"> <div style="width: 25px; height: 8px; cursor: move;"> <div handlebgcolor="true" style="overflow: hidden; background-color: rgb(196, 196, 173); width: 25px; height: 5px;"> </div></div></td></tr> <tr> <td style="height: 100%;"> <div bodybgcolor="true" style="overflow: hidden; background-color: rgb(236, 231, 224); width: 25px; height: 100%;"> <table cellspacing="0" cellpadding="0" border="0" style="overflow: hidden; width: 100%; table-layout: fixed; height: 100%;"> <tbody> <tr> <td> </td> <td style="width: 100%; height: 100%;"> <table cellspacing="0" cellpadding="0" border="0" id="wtbInquiryAction_tbic_Vertical" style="overflow: hidden; width: 100%; height: 100%;"> <tbody /></table></td> <td> </td></tr></tbody></table></div></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table><input type="hidden" id="wtbInquiryAction" style="display: none;" /><input type="hidden" name="wtbInquiryAction_h" id="wtbInquiryAction_h" />