QueryCellFormattedText event is not invoked for child tables in GridGroupingControl.
Example: take HierarchySample
Add to the constructor:
this.groupingGrid1.TableModel.QueryCellFormattedText += new GridCellTextEventHandler(TableModel_QueryCellFormattedText);
Add to Form:
private void TableModel_QueryCellFormattedText(object sender, GridCellTextEventArgs e)
Observe debug output, you will notice that only values for "Products" table are ever displayed.
IS there any way to have this event triggered for the child tables as well ?
There are different TableModels for each nested level, so you have to subscribe to the event for each level.
We will eventually add a TableModelQueryCellFormattedText event to GridGroupingControl.
What you can do now is loop through relations and then wire the event for each nested TableModel. You can iterate through groupingControl.TableDescriptor.Relations and then get a reference to the TableModel with groupingControl.GetTableModel(relationDescriptor.ChildTableName). Or if you know the names of the tables in your dataset, you can also call also groupingControl.GetTableModel(tableName). Once you have the GridTableModel you can wire the event.