The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
RCRajadurai C Syncfusion Team July 24, 2009 03:17 PM UTC
Hi David,
Thanks for your interest in Syncfusion Products.
From the update, it seems you are displaying summary in group caption. If it is, the aggregated value can be accessed from the caption summary through the GetSummaryText method of GridEngine. Here is the code for your reference handled in QueryCellStyleInfo event which retrieves the summary text from caption summary row. if (e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionSummaryCell) { Group g = e.TableCellIdentity.DisplayElement.ParentGroup; if (g != null) Console.WriteLine(GridEngine.GetSummaryText(g, scd)); }
Regards, Rajadurai
DCDavid CuiJuly 27, 2009 02:25 PM UTC
Thanks, Rajadurai,
Another Question: is there possible or easier way to export all of the summary values into a DataTable ? In another word, I don't need the record fields (details), ONLY need the summary values like a collapsed view (like export data to PDF/CSV for only viewable columns/rows) .
The purpose is to i want to get such values in DataTable format in order to fit to other reports.
best,
David
RCRajadurai C Syncfusion Team July 28, 2009 02:03 PM UTC
Hi David,
Thanks for your update.
In gridgroupingcontrol, you can export the summary view(collapsed view) to excel sheet using GroupingGridExcelConverterControl or save it to XML file and restore it back in grid using the following code. this.gridGroupingControl1.Engine.InitializeFrom(GridEngine.CreateFromXml(xr));//xr is XmlReader object this.gridGroupingControl1.WriteXmlSchema(xw);//xw is XmlTextWriter object
But it is not possible to save it in datatable format.
Please let me know if you have any further queries.