can I use Max or Min for string type for Summary Column of GGC ?

[David Cui]

Hi,

For summary column of GGC, it works fine like SUM/MAX for numerical column.

can I use Max or Min for string type for Summary Column of GGC ?
if not, what is the workaround ?

best,

David

[Kathiresan M]

Hi,

I'm not very much clear with your query. What you do mean by MAX/MIN in string? Did you mean the characters count?

We've couple of samples demonstrating "Summary". Please refer the shipped sample from the below location regarding "Summary".

..\My Documents\syncfusion\essentialstudio\7.3.0.7\Windows\Grid.Grouping.Windows\Samples\2.0\Calculate Summary

Thanks,
Kathir

[David Cui]

thx,

Max is the same as TSQL .
Am I clear ?

david

[David Cui]

we want to extract group's child of some column's value (assume all of them value are the same) directly to Summary Row's certain column automatically (like you did sum/count for numerical fields) ?
am i clear ?

david

[Rajadurai C]

Hi David,

Thanks for your update.

If you would like to display the value of column(by which grid has been grouped) in the summary row, it can be achieved by handling the summary row in QueryCellStyleInfo event with the following code.

if (e.TableCellIdentity.TableCellType == GridTableCellType.SummaryFieldCell)
{
     GridSummaryRow row = e.TableCellIdentity.DisplayElement as GridSummaryRow;
     e.Style.Text  = row.ParentGroup.Records[0].GetValue("Department").ToString();
}

Here is a minimal sample for your reference, in which the child groups has summary row with value of 'Department' column.
http://files.syncfusion.com/support/samples/Grid.Windows/7.3.0.20/F88742.zip

Regards,
Rajadurai