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???
If Mike has his ears open he might be able to shed some light on that for you. Unfortunately I have not worked with either (still learning the control).
Thanks for the response.
However, I do have a strong requirement that I have to use BindingList, and not UltraDataSource, and I do handle at least 100 rows with 80 columns, and all the values are updated every second.
Looking at the example, is it possible to achieve it with IGroupByEvaluator?
Or, I was looking into 9.1 library, and it had a new feature "Grouping Columns in Row Layout ". Can this meet my needs?
Take a look at this thread:
http://forums.infragistics.com/forums/p/25424/96135.aspx#96135
The differences in comparing your requirements to mine:
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?