Grid.Group([0, 2]);  // Group by the first and third columns

This will group the rows by Department first and then by Salary within each department group.

Custom Grouping Logic

TTMSFNCDataGrid provides flexibility by allowing you to define custom grouping logic. This is useful when you want to group by derived values or need more complex conditions for grouping.

Using the OnGetCustomGroup event

To implement custom logic, you can use the OnGetCustomGroup event. Here's an example where we group employees based on whether their salary is above or below 55,000, rather than by the salary value itself:

procedure TForm1.GridGetCustomGroup(Sender: TObject; ACell: TTMSFNCDataGridCellCoord; 
                                    AData: TTMSFNCDataGridCellValue; 
                                    ALevel: Integer; var AGroup: string);
begin
  if ACell.Column = 2 then
  begin
    if AData.AsInteger > 55000 then
      AGroup := 'Above 55K'
    else
      AGroup := 'Below 55K';
  end;
end;

In this case, instead of grouping by the exact salary values, the data will be grouped into "Above 55K" and "Below 55K" categories. You can then call the Group method like this:

Grid.Group(2);

Advanced Grouping Options

• Summary: Add a summary row at the end of each group.
• MergeHeader: Merge grouped column headers for a cleaner look.
• AutoSort: Automatically sort rows when a group is created.

procedure TForm1.GridGetGroupOptions(Sender: TObject; AColumns: TArray<Integer>; 
                                     ALevel: Integer; var AOptions: TTMSFNCDataGridDataGroupOptions);
begin
  AOptions.Summary := True;
  AOptions.MergeHeader := True;
  AOptions.AutoSort := True;
end;

Conclusion

Grouping in TTMSFNCDataGrid is a powerful feature that enhances data organization and allows for more complex data manipulation. Whether you're grouping by a single column, multiple columns, or using custom logic, TTMSFNCDataGrid offers a flexible and robust set of options.

By utilizing events such as `OnGetCustomGroup` and `OnGetGroupOptions`, you can create custom groupings and apply advanced settings to your data grid, allowing for better data presentation and user interaction.

With grouping, you enable users to explore and analyze data efficiently. So, whether you're working on a business application with financial data or an inventory management system, TTMSFNCDataGrid’s grouping functionality can significantly improve data usability and insights.

In the next blog we'll explore how you can add real controls to cells, so stay tuned for more advanced tips and tutorials on leveraging this next-generation data grid for your Delphi projects! Happy coding!