Caption Summary shows wrong total

[Harshad]

Hi,

I am implementing SfDataGrid in a WPF app and have Groupings and Caption totals.  It shows correct values when the data source is prepopulated and then the control is rendered.  However, when data source is refreshed on click of a button, the caption totals are wrong.  Please see the attached with explanation and examples.

Thank you in advance for your help.

Regards.

Harshad

Attachment: SfDataGrid_Caption_Total_Issue_f6ec2ffe.zip

[Dhivyabharathi Dakshinamurthy]

Hi Harshad,

Based on the provided information, we have also replicated the reported scenario where 'SummaryRows' totals are not calculated properly when data source is refreshed. You mentioned that you are refreshing the datasource in the button click and calling the same 'GetData()' method. Could you please share the code snippets used in the Button click and the 'GetData()' method.

We have also attached the issue-replicated sample for your reference. Could you please confirm if this approach is similar to yours or if it differs? If possible, could you please provide your own sample? It will help us provide a better solution.

[Dhivyabharathi Dakshinamurthy]

Hi Harshad,

Kindly find the attachment here.

Attachment: SfDataGrid_Demo_3c0e4d6e.zip

[Harshad]

Thank you for looking into this issue.

I am doing exactly what you have done in your attached demo code except that a) instead of inline order data, I am fetching records, in viewmodel, from SQLite database and b) I am taking both actions of your two buttons in one single button - ie clearing the datasource and repopulating it.

Also, as I explained in my original attachment, I am seeing results like your demo code.

Thank you once again.

I look forward to the resolution at your convenience. 

Best regards

Harshad

[Dhivyabharathi Dakshinamurthy]

Hi Harshad,

 

We have checked the reported issue “Summary values are not calculated properly when the bound collection is cleared and re-populated” on our end and it is confirmed as a defect. And We have logged a bug. We will fix this issue and include it in our NuGet release Which is scheduled on May 14, 2024.

You can track the status of this report through the following feedback link,

 

Feedback Link: Summary values are not calculated properly when the bound collection is cleared and re-populated in WPF | Feedback Portal (syncfusion.com)

 

Note: The provided feedback link is private, and you need to log in to view this feedback.

 

We will let you know once it is released. We appreciate your patience until then.

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.
 

[Harshad]

Thank you for your continued support!

Kind regards

Harshad

[Dhivyabharathi Dakshinamurthy]

Hi Harshad,

We regret the inconvenience.

We are unable to include the fix for this issue in our NuGet package which is released today as promised. We will fix this issue and include it in our Weekly NuGet release which is scheduled on May 28, 2024.

[Harshad]

No worries,  Thank you for your continued support!

[Dhivyabharathi Dakshinamurthy]

Hi Harshad,

 

We regret the inconvenience.

We are unable to include the fix for this issue in our NuGet package which is released today as promised. We will fix this issue and include it in our Weekly NuGet release which is scheduled on June 11, 2024.

 

We will let you know once it is released. We appreciate your patience until then.

[Harshad]

No worries.

Thank you for the update.

[Dhivyabharathi Dakshinamurthy]

Hi Harshad,

We regret for the inconvenience. Due to main release, we are unable to fix this issue We have identified the cause of the issue and currently working on a fixing the issue. We will make the necessary changes and include them in our upcoming NuGet release followed by main release.


We will inform you once it is released. We appreciate your patience until then.

[Harshad]

No worries.  Thanks

[Manikanda Akash Munisamy]

Hi Harshad,

We would like to let you know that Essential Studio Weekly NuGet packages (v26.1.38) has been published in nuget.org with the fix for the issue "Summary values are not calculated properly when the bound collection is cleared and re-populated". Please let us know if you have any concerns in this.

 

Root Cause Details:

In the reported scenario, after refreshing the item source, we obtained the separate bottom-level groups and then added them to the TopLevelGroup. However, the issue arose because we updated the Caption Summaries for the group before adding it to the TopLevelGroup. We have now ensured that the summary values are calculated properly after adding them to the TopLevelGroup.

Regards,
Manikanda Akash

[Harshad]

Hi Akash,

I upgraded my components to version 26.1.38 but the issue still persists.  Do I need to install any other component in order for this to work?

BTW, in the screenshot below you may wonder that there is one update available.  However, that is for Microsoft.Extensions.Hosting which is not for my platform and is irrelevant to Syncfusion components. 

Thanks

Harshad

[Harshad]

Please ignore my previous message.  I noticed that there is a new attribute that needs to be added.  I added the following and it works like a charm!

LiveDataUpdateMode="AllowDataShaping"

Excellent support!

Thank you.

Harshad

[Manikanda Akash Munisamy]

Hi Harshad,

We glad that the query was addressed from your side. If you have any other queries, please create a new ticket.

Hence, we are closing this ticket.

Regards,
Manikanda Akash