Seems I cant figure out anything on my own. Anyway, looking to set a total for a column in the footer. I see examples for the UltraWebGrid but nothing for the WebDataGrid. Thanks.
I'm having similar difficulties. I read this entire thread and tried everything that was suggested and yet cannot get a footer to display. This was so much easier on the UltraWebGrid! Have you figured out how to do this using server-side code? All I want to do is display a simple column total in the footer! It seems I must be missing something to enable footers. I can't get anything to show in the footers! Any help would be appreciated. The documentation for this product is totally useless and there's zero information in the KB.
Bud -
You should just be able to turn footers on like:
<ig:WebDataGrid ID="grid1" runat="server" ShowFooter="True">
Each column would then have footer markup like:
<ig:BoundDataField DataFieldName="Current_Month_Activity" Key="Current_Month_Activity" CssClass="cellRight" DataFormatString="{0:$#,##0.00}" Width="80px"> <Header Text="Current Month Activity" CssClass="cellRight" /> <Footer CssClass="gridFooter" /> </ig:BoundDataField>
You can reference the footers in the code behind as well (this is me using .NET's DataTable.Compute):
//in page load
grid1.Columns["Current_Month_Activity"].Footer.Text = String.Format("{0:C}", Convert.ToDecimal(data.Compute("Sum([Current_Month_Activity])", "")));
Does this help?