TDBAdvGrid floatingfooter text format

VCL TMS VCL UI Pack
1

Hi TMS Support,

Here is what I'm trying to do. I add a "FloatingFooter" to my "TDbAdvGrid" and everything is fine. I want to add an "acSum" to the column that I need it. My query is always close, so when I open it I use "DBAdvGrid.FloatingFooter.ColumnCalc[Index] := acSum". I need to add this every time I open the query, if not the footer is empty. Is that normal ?

My other question is : I want to add a "Money format" using "Format('%m', [500])", to show the value in the footer with the money format. Is there any way to do this ?
I look at the example 44 of the "TAdvStringGrid" and try to use event "OnGetDisplText", but it doesn't work.

Can anyone help me with this problem ?

Thank you very much

2

  1. When you open a new query, set
    DBAdvGrid.FloatingFooter.ColumnCalc[Index] := acSum again to force a recalculation.

  2. Implement the event OnGetFloatFormat to specify the number float format for the last row of the grid.

3

It works really well!

Thank you very much Bruno