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?
ADAdministrator Syncfusion Team March 15, 2005 01:04 AM UTC
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.
VBvbakerMarch 15, 2005 06:22 PM UTC
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.
ADAdministrator Syncfusion Team March 16, 2005 02:36 PM UTC
If I understand what you want, here is sample that does it.
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.