TDBAdvGrid Summary Band

VCL TMS VCL UI Pack
1

I need to include a summary of certain values in TDBAdvGrid - Sum per column. 


IE.
1   2   3 
4   5   6
======
5   7   9

* however I need to anchor the summary to the bottom of the grid window and lock it in place regardless of vertical scrolling by user. Is this possible? If so can you provide a code sample?

Dave.
2
I've made some progress using the following code... 

  with grdDetail.FloatingFooter do begin
    FooterStyle:= fsFixedLastRow;
    Visible:= True; // This has to be true before we attach the dataset, otherwise the last row is not included in the sum.
    for i := 0 to grdDetail.ColCount -1 do begin
      if grdDetail.Columns[ i ].FieldName = 'INVTOTAL' then begin
        ColumnCalc:= acSUM;
      end else if grdDetail.Columns[ i ].FieldName = 'BNKTOTAL' then begin
        ColumnCalc:= acSUM;
      end else begin
        ColumnCalc:= acCUSTOM;
      end;
    end;
    Height:= grdDetail.DefaultRowHeight + 1; 
    BorderColor:= clBlack;
    EnableCalculation:= True;
    Invalidate;
  end;

My current challenge involves a checkbox appearing on top of the column header text in a checkbox column.

Dave.
3

Did you try to call grid.AddCheckBox() for the column header cell?