TDBAdvGrid floatingfooter text format

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

  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.

It works really well!

Thank you very much Bruno

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.