We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

No grouping for NULL values in SfDataGrid

Hi,

is it possible to group a column but without a group header and without a summary row for NULL values.

Suppose you have the following data source:
producercountrycount
BMW
123
Mercedes
235
VW
222
Porsche
432
RenaultFrance70
CitroenFrance67
MaseratiItaly54
Alfa RomeoItaly22
FiatItaly12
ToyotaJapan156
HyundaiJapan87
MazdaJapan44

With grouping on column country SfDataGrid displays:
(sorry for the poor presentation)
> Country:
      BMW123
      Mercedes235
      VW222
      Porsche
432
> Country: France
      Renault
70
      Citroen
67
> Country: Italy
      Maserati
54
      Alfa Romeo
22
      Fiat
12
> Country: Japan
      Toyota
156
      Hyundai
87
      Mazda
44

But I would like to have:
BMW123
Mercedes235
VW222
Porsche
432
> Country: France
      Renault
70
      Citroen
67
> Country: Italy
      Maserati
54
      Alfa Romeo
22
      Fiat
12
> Country: Japan
      Toyota
156
      Hyundai
87
      Mazda
44

Can you provide any hints?

Regards
Harald

1 Reply

BR Balamurugan Rajaraman Syncfusion Team December 9, 2016 02:07 PM UTC

Hi Harald, 
You can achieve your query “No grouping for NULL values in SfDataGrid” by setting the summary Row height as 0 when the null value is grouped. We attached the sample based on your query for your reference Please find the samples from the below link. 
 
Sample Link: 
Regards, 
Balamurugan 


Loader.
Live Chat Icon For mobile
Up arrow icon