Getting a summary value

Hi Michael,

You can use the GetSummaries method to get the summary value at the specified Table. Below is a code snippet.

//For MainTable.
GridTable table = this.grid.Table;

//For AnyTable...
GridTable table= this.grid.GetTable("TableName");

int indexofSummaryColumn = 0;

Int32AggregateSummary summary1 = (Int32AggregateSummary) table.GetSummaries()[indexofSummaryColumn];
if(summary1 != null)
{
Console.WriteLine("Sum : " summary1.Sum + "::: Min " + summary1.Minimum + "::: Max " + summary1.Maximum);
}

Let me know if this helps.

Thanks,
Haneef

Here how come i come to know that which level group summary i am getting...

I want summary cell value for the group level 2...
I have the group object. Using this group object can i get the summary value?

Hi,

Thank you for being patience.

The GroupLevel property can be used to check for the level of the group summary. The Summaries for the group can be retrieved by using GetSummaries method. Please refer to the following code snippet for more details.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
// QueryCellStyleInfo event
Group g = el.ParentGroup;
System.Diagnostics.Trace.WriteLine(g.GroupLevel);

ITreeTableSummary[] summaries = g.GetSummaries(g.ParentTable);
SummaryDescriptorCollection sdc = e.TableCellIdentity.Table.TableDescriptor.Summaries;
Int index = sdc.IndexOf(sdc["priceSummary"]);
DoubleAggregateSummary summaryPrice = summaries[index] as DoubleAggregateSummary;

index = sdc.IndexOf(sdc["volumeSummary"]);
Int32AggregateSummary summaryVolume = summaries[index] as Int32AggregateSummary;

string text = indentString + "groupedBy: " + g.CategoryKeys[0].ToString();
text += string.Format(" high:{0:F2} low:{1:F2} volume:{2:F0}", summaryPrice.Maximum, summaryPrice.Minimum, summaryVolume.Sum) + Environment.NewLine;
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Kindly let us know if you need any further assistance.
Have a nice day.

Best regards,
Madhan