We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

DoubleAggregate summary for Sum function is not working when ItemsSource is a DataTable

DoubleAggregate functions are not shown when ItemsSource is assigned as a DataTable

Here is my simplified code;

        datagrid.Columns.Add(new DataGridNumericColumn() { MappingName = "VALUE", HeaderText = "Value", Width = 180 });

        DataTable DT=new DataTable();

DataGridTableSummaryRow summaryRow = new DataGridTableSummaryRow();
        summaryRow.ShowSummaryInRow = false;
        summaryRow.SummaryColumns.Add(new DataGridSummaryColumn()
            Name = "TableSummary",
            MappingName = "VALUE",
            Format = "{Sum:C0}",
            SummaryType = SummaryType.DoubleAggregate

        datagrid.ItemsSource = DT;

When data is created with corresponding ObservableCollection(MyRowItem), Sum value is shown as expected with the same summary creation code.

Am i missing something here?

Best Regards


3 Replies

NY Nirmalkumar Yuvaraj Syncfusion Team April 27, 2023 11:39 AM UTC

Hi Ender,

We have checked your query at our end, and we are able to replicate that issue at our end. We have considered this as a bug and logged a bug report regarding this in our feedback portal. We will fix the reported issue and include the changes in our upcoming weekly patch release, which is expected to be rolled out on May 16, 2023. We will let you know once released, and we appreciate your patience until then. You can also track the status of the bug using the feedback link below. 

Feedback Linkhttps://www.syncfusion.com/feedback/43251/doubleaggregate-summary-for-sum-function-not-working-with-datatable-as-itemssource



EK Ender Karadag April 27, 2023 02:05 PM UTC

Thanks for the reply. Custom summary with DataGridTableSummaryCellRenderer shows summary rows after manually calculating the aggregate function.

Can the summary row be sticked bottom for winui?  it looks bad while scrolling (espicially down) as if it has a ui bug somewhere.

I have attached a gif file

Thanks in advance



Attachment: SFDataGrid_c076cb22.zip

NY Nirmalkumar Yuvaraj Syncfusion Team May 2, 2023 12:23 PM UTC

Hi Ender,

This is already a known issue. It occurs when scrolling with the mouse wheel. The issue is happening because the scroll view is bouncing. Unfortunately, the framework does not provide an option to limit this. However, we will explore possible solutions to address the problem from our side. Trying to scroll with the thumb track might be more advantageous.

I hope this helps! Please let us know if you have any further queries on this. We are happy to help you.



Live Chat Icon For mobile
Up arrow icon