Search code examples
c#.netlinqinfragistics

Use Last Value in Column for Summary Instead of SUM

I have following code to remove the summary row/band value on a retrieve UI event. I'm certain this is the wrong way to do it but it works.

public UiEventResult AfterRetrieveData_111(object sender, RetrieveDataEventArgs e)
    {
        UltraGridBase baseGrid = _view.ViewGrids["ultraGrid1"];
        UltraGridLayout gridLayout = baseGrid.DisplayLayout;
        
        for (int i = 0; i < 2; i++)
        {
            gridLayout.Bands[i].Columns["columnA"].Formula = "''";
        }
        for (int i = 0; i < 3; i++)
        {
            gridLayout.Bands[i].Columns["columnB"].Formula = "''";
            gridLayout.Bands[i].Columns["columnC"].Formula = "''";
        }

Is there a way to program the retrieve so that it populates the summary row for column A/band[2] so that is uses the last value in each column? Without the above code it will sum rows under but would like for a way for it to use the last row value instead. Data will always be sorted DESC by date so last row will always be the value needed...

enter image description here

Solution

  • This will loop through ChildBands and set parent row value with the last value in each ChildBand.

    int rowCount = gridLayout.Rows.Count;
for (int i = 0; i < rowCount; i++)
{
foreach (UltraGridChildBand childBand in baseGrid.Rows[i].ChildBands)
     {
      foreach (UltraGridRow row in childBand.Rows)
          {
           row.Cells["columnA"].Value =row.ChildBands.LastRow.Cells["columnA"].Value;
          }
     }
            
}