show sum of the time column in GGC (ver : 7.2.0.37 )

[Ali]

i m using 7.2.0.37 and want to show sum of the time column in GGC , please help me and send a sample if it is possible ,

 Regards
A.Abedini

[Asarudheen S]

Hi Abedini,

 

Thank you for your interest in Syncfusion products.

 

You can achieve the reported behavior “sum of the time column in GGC” through the feature expression column. A sample regarding   this has been shipped   in the our dashboard. Please refer the following location for the sample.

 

..\..\AppData\Local\Syncfusion\EssentialStudio\10.2.0.55\Windows\Grid.Grouping.Windows\Samples\2.0\Filters and Expressions\Expression Field Demo

 

Please refer the following code to make the sum for the time column.

 

          string expressionName = "Expression 1";

                GridColumnDescriptor gridExprColumn = new GridColumnDescriptor();

            gridExprColumn.MappingName = expressionName;

            this.gridGroupingControl1.TableDescriptor.Columns.Add(gridExprColumn);

           

            this.gridGroupingControl1.TableDescriptor.ExpressionFields.Add(expressionName);

       

 

            this.gridGroupingControl1.TableDescriptor.ExpressionFields[expressionName].Expression = "[Time1] +[Time2]";

            this.gridGroupingControl1.TableDescriptor.ExpressionFields[expressionName].ResultType = "System.Date";

            this.gridGroupingControl1.TableDescriptor.VisibleColumns.Insert(index, expressionName);

 

Please let us know if you need any further assistance.

 

Regards,

Asaryudheen.