Grouping gurus, please help. We''re currently evaluating Syncfusion and some other third parties grid.
I like syncfusion and would like to show to the other devs that what we want to accomplish is possible with
Syncfusion.
Here''s the problem!
I have a source of data as depicted in the list below.
I want to be able to group by item and price. However, when I
used the GGC, it groups the data first by item and then by price.
I want to group by item and price at the same level.
I am trying to accomplish the fllw:
1. I want to group by two fields combine in the datasource.
2. I do not want to show the child items in the grid when grouped. I only want to show the group summary.
2. Most importantly, I want to show the group summary in a regular grid like in figures 1 and 2 WITH EDITABLE CELLS or just like how the child tables are displayed,
but GGC shows the summary as static caption. This will enable be to update "count1" or "count2" in figure 2, for example, and
I would manually update the underlying datasource.
Can somebody please help me?
datasource (figure 1).
id item price bit1 bit2
------------------------------------
1 item_1, 10, 1, 1
2 item_1, 20, 0, 1
3 item_2, 15, 1, 1
4 item_2, 15, 0, 1
5 item_2, 30, 0, 1
6 item_1, 10, 1, 0
group by item and price (figure 2).
item price count1 count2 total
-------------------------------------
item_1 10, 2, 1, 3
item_1 20, 0, 1, 1
item_2 20, 0, 1, 1
item_2 15, 1, 2, 3
group by item. (figure 3)
item price count1 count2 total
-------------------------------------
item_1 10, 2, 2, 4
item_2 20, 1, 3, 2
data2.zip