Customize on runtime placed SummaryItem Sum in footer to ignore specific rows

Hello Enis,

Thank you for the sample. In this case, you can handle the TotalSummary.CollectionChanged event of the GridControl and set the dxg:TreeListSummarySettings.IsRecursive attached property in the event handler, like so:

C#
public MainWindow()
{
    InitializeComponent();
    // ...
    gc.TotalSummary.CollectionChanged += TotalSummary_CollectionChanged;
}

private void TotalSummary_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
    foreach (GridSummaryItem summary in sender as GridSummaryItemCollection)
    {
        if (summary.SummaryType == DevExpress.Data.SummaryItemType.Sum)
        {
            TreeListSummarySettings.SetIsRecursive(summary, false);
        }
    }
    gc.UpdateTotalSummary();
}

In the code snippet above, you will notice that I called the UpdateTotalSummary method. This makes sure that the TotalSummary values are updated to reflect the changes. I've modified your sample to demonstrate this idea in action. Please try this on your side and let us know the results.

Thanks,
Raphael

Hi,

thank you.
It works, so the primary requirement is achieved.

But i'm still interested in the question, if it's possible to control the summary calculation similar to the GridControl custom summary event, to solve further requirement in the future.

Hello Enis,

Thank you for the update. I am happy to hear that the issue is now resolved. As for your question regarding custom summary at runtime, our Runtime Summary Editor only has four built-in aggregate functions: Min, Max, Average, and Sum. Since the CustomSummary event is only fired when a SummaryItem's SummaryType is Custom, the event will not be fired when creating a summary item via the Runtime Summary Editor.

If you would like to include custom options that uses the CustomSummary event, we've discussed a similar issue in How to add a user's options into Group Summary Editor. Please note that if the GridControl uses the TreeListView, use the TreeListView.CustomSummary event instead. Please try this on your side and let us know if you need further assistance.

Thanks,
Raphael