Hide Empty Group

[Andy]

Hi,

I have a SFDataGrid which has a TextColumn and a GridComboBoxColumn. The data is grouped by the id of a Id/Value object whose content can be selected via the combobox column (2. Column).

I want to show also the groups that are empty (like Group 2 and Group 4).

Is it possible to show only the group headers if a group is empty and not the row (Criteria: 1.Column is Null)? 

Thanks for your help!

Maria

[Lakshmi Natarajan]

Hi Maria, 

 

Thank you for using Syncfusion products. 

 

We have checked the reported query “Hide Empty Group” from our side. We would like to inform you that you can customize the RowHeight by using SfDataGrid.QueryRowHeight event.  

 

Please refer to our user guidance document regarding the same, 

UG link: https://help.syncfusion.com/xamarin/datagrid/row-height-customization#queryrowheight 

 

Please refer to the following code snippets to achieve your requirement, 

private void dataGrid_QueryRowHeight(object sender, QueryRowHeightEventArgs e) 

{ 

    var item = dataGrid.GetRecordAtRowIndex(e.RowIndex) as OrderInfo; 

    var isGrouped = dataGrid.GroupColumnDescriptions.Count > 0; 

             

    if (item != null && isGrouped && string.IsNullOrEmpty(item.FirstName)) 

    { 

        e.Height = 0; 

        e.Handled = true; 

    } 

} 

 

We have prepared a sample based on your requirement and attached in the following link, 

Sample: https://www.syncfusion.com/downloads/support/forum/169958/ze/GettingStarted-1423878951 

 

Output 

 

 

Please let us know if you need further assistance. 

 

Regards, 

Lakshmi Natarajan 

 

[Andy]

Thank you! It works like charm!

[Suja Venkatesan]

Hi Maria, 

Thanks for the update.  

We are glad to know that the provided solution worked at your end. Please let us know if you need any other assistance.   

Regards, 

Suja.