I group by 3 columns: Country, State, and City
The data are:
Row 1: US, California, LA
Row 2: US, NewYork, NY
Row 3: Japan, -, TK
Then, it will be grouped as the following:
1st Group: US (With Subgroup of California and New York, and with 2nd SubGroup of LA and NY)
2nd Group: Japan (With empty Subgroup, and with 2nd SubGroup of TK)
Like WinTree's FreeForm, is there a way to remove the empty SubGroup Row in the 2nd Group?
(Like having Japan -> TK then instead of Japan -> (1) -> TK)
Is there a way to do this???
No, there is no way to do this in the grid.
Can't we do this with Multiple Bands?
Indeed, can we apply different grouping per band? (Like each band to represent different grouping, and apply individial group-by to each band?)
Hi,
Regard to the above question, is there any way to achieve this (remove the empty group) by any mean? (Multi-Band, or Tree's Free form)
I need something that performs as well as the current wingrid's group-by-row, as I am currently handling more than 1000 rows, and also has like 10-100 groups, each with different level of sub-groups.
The only way to do this would be to do it on the DataSource, not in the grid or the tree. In which case, you would have to handle the grouping yourself.
Sorry if I was unclear.
Neither the grid nor the tree can simply hide a band and still show it's child rows. My only suggestion is that you build a data source in which the grouping is already done. In other words, you bind the grid to a data source with only 2 bands which contains only the rows you want. Then you would not even need the GroupBy functionality of the grid, as the data in the data source would already be grouped.
You could, for example, create an UltraDataSource and set it up with 2 bands and populate it with data from the first and third bands of your actual data.
What do you mean by Data Source? You mean to have this grouped row in my data source?
Can you be more precise?