Group caption with editable cells and hide group child table, (attachment)

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

Hi James,

Thanks for your confidence in our product.

We are currently working on the sample with the requirements specified which we will update you soon. Thanks for being patience.

Best regards,
Madhan

Thanks for looking into this for me!
James,

>Hi James,

Thanks for your confidence in our product.

We are currently working on the sample with the requirements specified which we will update you soon. Thanks for being patience.

Best regards,
Madhan

Hi James,

Thanks for being patience.

Please open a D-Trac incident to have further details and for the answer on this issue. For more details on opening a new D-Trac incident, please contact our sales team ( sales@syncfusion.com ).

Thanks,
Madhan