DBAdvGrid Header Row and FilterEdit

VCL TMS VCL UI Pack
1


Using D10 Seattle, DBAdvGrid ver 2.3.8.9.

PageMode:=false;
AutoCreateColumns:= true;

Set SQL and open dataset at run time (FDQuery) (no persistent columns).

If FixedRows:=2, opening the dataset will show the display labels in row 1, not 0, and data appears (as expected) starting in row 2.S

That is, with FixedRows>1, the column headers appear in the last fixed row.

There does not appear to be an option to set the column header row that would allow:

[ ][Header 1  ][Header 2  ]...
[ ][filter          ][filter          ]...
[ ][data          ][data          ]...
[ ]...

If I set the following:
 DBAdvGrid1.FixedRows:=2;
 DBAdvGrid1.FilterEdit.Row:=0;
 DBAdvGrid1.SortSettings.Row:=1;
 DBAdvGrid1.FilterEdit.Enabled:=True;

Then I can at least set the FilterEdit row above the column headings, and have the sort invoked when hitting row 1 (column headers and SortSettings row).

But visually it doesn't really strike me as "quite right" - I'd prefer the filter row below the column header row.

Is there some work around that would let me set "RowHeaders Row" ?

TIA.

EdB




2

You would have to set the header row in this case programmatically via grid.Cells[column, 0].

You're correct that this isn't very convenient in this case and as such, we have introduced the property grid.HeaderRow: integer that will allow you to specify this row. This new property will be available in the next update.
3

Perfect! 

Thanks Bruno.

Cheers,
EdB