I'm attempting to display a column total on my UltraWebGrid - but I cannot get it to display. I'm sure it is something obvious but I have been staring at it so long that I'm ready to give up! Can anybody see what I might be doing wrong:
<code>
UltraWebGrid1.DisplayLayout.Bands(0).ColFootersVisible = Infragistics.WebUI.UltraWebGrid.ShowMarginInfo.Yes UltraWebGrid1.DisplayLayout.Bands(0).FooterStyle.BackColor = Drawing.Color.FloralWhite UltraWebGrid1.DisplayLayout.Bands(0).FooterStyle.ForeColor = Drawing.Color.Black UltraWebGrid1.DisplayLayout.Bands(0).FooterStyle.Height = 5 With UltraWebGrid1.DisplayLayout.Bands(0).Columns.FromKey("extPrice") .Footer.Total = Infragistics.WebUI.UltraWebGrid.SummaryInfo.Sum .FooterStyle.HorizontalAlign = HorizontalAlign.Right .FooterStyle.Padding.Left = New Unit(6) .Footer.Caption = "SubTotal:" End With
</code>
When I run the program, I see the footer and the word "subtotal" - but no total
Thanks in advance!
JCC
OK, I figured this out - I had the sum code in the load. I moved it to the UpdateRow event and it is working. I do have another question though. I would like to take that footer value and store it in a variable (most likely a hidden field) so that I can add it to some other values (the running footer subtotal needs to be added to 2 additional values that are outside the grid). It seems like I should be able to use this value by doing this:
txtSubtotal.Text = UltraWebGrid1.DisplayLayout.Bands(0).Columns.FromKey("extPrice").Footer.Total
But when I run it, only the number "1" shows in that field.
Is what I am trying to do possible? If som can oyu help me with the syntax
Thanks in advance for your help!