GridGrouping Summary Row Title

[vbaker]

I have a GridGroupingControl with Master-Details data. When I add a Summary Row to show the sum of values of one of the columns in the Master data, only the first letter of the summary row title is visible. How can I fix this?

Also, how can I create a second summary row that displays a grand total of the values of a column contained in the details data?

Thanks,
Van Baker

[Administrator]

Here is a sample showing how you can use TableModel.QueryCoveredRange to let the cell holding the row title to expand to 2 cells. It also shows a summary in the detail nested table.

http://www.syncfusion.com/Support/user/uploads/CS_c7b078fd.zip

[vbaker]

That helps with the column span issue (although repainting evidently needs to be tweaked if the title spans more that 2 columns and the grid is scrolled horizontally.)

But, I also wanted to display the grand total of all the values of a column in the nested table using a summary row in the master table. Is this possible?

>Here is a sample showing how you can use TableModel.QueryCoveredRange to let the cell holding the row title to expand to 2 cells. It also shows a summary in the detail nested table.
>
>http://www.syncfusion.com/Support/user/uploads/CS_c7b078fd.zip
>

[Administrator]

If I understand what you want, here is sample that does it.

http://www.syncfusion.com/Support/user/uploads/GGC_MasterDetails_20e9a82d.zip

It adds a second summary row to the master table which serves as a place holder. Then this placeholder row is populated in a QueryCellStyleInfo event. To get the value that is displayed, the nested details table is set as the data source for a Grouping.Engine object. This object is used to manage the summary calculation that you want on the whole child table.