Summary issue, it dont count

[Daniel]

Hi!

I tried to add a summary to my grid but doesn´t work. I tried a summary with numbers and false/true count and neither works.

Did I forget something to make it work?

This is my View:

And datasource:

Thanks, regards!

[Vignesh Natarajan]

Hi Daniel, 

Thanks for using Syncfusion products. 

We have analyzed your query and we are able to reproduce the reported issue. While using remote data Summary Row must be handled in the server side by returning the summary column dataSource into the aggregates property of result object.  

Please refer the below code snippet (server side) 

if (dm.Aggregates != null) 

            { 

                for (var i = 0; i < dm.Aggregates.Count; i++) 

                    str.Add(dm.Aggregates[i].Field); 

 

            } 

            IEnumerable aggregate = ds.PerformSelect(DataSource, str); 

            var count = order.Count(); 

            DataSource = ds.PerformSkip(DataSource, dm.Skip); 

            DataSource = ds.PerformTake(DataSource, dm.Take); 

            return Json(new { result = DataSource, count = count, aggregate = aggregate }); 

Refer the below code snippet for the output 

 

For your convenience we have prepared a sample which can be downloaded from below link 

Sample: http://www.syncfusion.com/downloads/support/forum/133403/ze/SyncfusionMvcApplication40-2007645102  

Refer our online documentation for your reference 

https://help.syncfusion.com/aspnetmvc/grid/summary?cs-save-lang=1&cs-lang=razor#handling-aggregation-in-server-side  

Regards, 

Vignesh Natarajan 

[Daniel]

Perfect! It works, that was the missing thing. Another question related to summary... is it possible to add a new line that summatize all totals?

Thanks, regards!

[Vignesh Natarajan]

Hi Daniel, 

 

Thanks for the update. 

 

Query: “is it possible to add a new line that summatize all totals?” 

 

We have analyzed your query and we have achieved your requirement through the Custom summary feature of the Grid. Please the below code snippet. 

 

                   . 

                   . 

                   . 

.SummaryRow(row => 

                   { 

                       row.Title("Total").SummaryColumns(col => { col.SummaryType(SummaryType.Sum).DisplayColumn("Freight").DataMember("Freight").Add(); col.SummaryType(SummaryType.Sum).DisplayColumn("Number").DataMember("Number").Add(); }).Add(); 

                       row.Title("Full Total").SummaryColumns(col => { col.SummaryType(SummaryType.Custom).CustomSummaryValue("Total").DisplayColumn("Freight").Add(); }).Add(); 

                   })  

             .  

             . 

             . 

<script type="text/javascript"> 

     function Total() { 

         return this._remoteSummaryData["Freight - sum"] + this._remoteSummaryData["Number - sum"]; 

  } 

    </script> 

 

Refer the below code snippet for output 

 

 

 

For your convenience we have prepared a sample which can be downloaded from below link 

 

Sample: http://www.syncfusion.com/downloads/support/forum/133403/ze/SyncfusionMvcApplication40-941289507  

 

Refer our help documentation for your reference 

 

https://help.syncfusion.com/aspnetmvc/grid/summary?cs-save-lang=1&cs-lang=js#custom-summary  

 

Regards, 

Vignesh Natarajan 

 

 

[Daniel]

Perfect!

Works fine, thanks for your help.

Regards!

[Vignesh Natarajan]

Hi Daniel, 

Thanks for the update. 

We are glad that your query has been resolved by our solution. 

Please get back to us, if you need any assistance in future. 

Regards, 

Vignesh Natarajan