Caption Summary Row As Sum Shows -0.00

[Sabian Sirius]

Hi,

I am using SfDataGrid with Group View and Caption Summary Row, and also Master Detail View. Code is written in vb.net (.net 8).  

When I execute code (program) form is showing Caption Summary Row as it should be but the Sum in one column is -0.00. The sum of that column is 0 but I don't know why is showing minus in front of 0 value. I used same code when I wrote this code in vb.net (.net framework 4.8) and there was no problem.

For some reason now it shows value of -0.00. 

I added images and code to show how it looks like. I hope you will manage.

I don't know if the reason is that negative values is first to come, or because there is Master Detail View included.

Please can you tell me why summary row shows negative zero value.

If it is needed, I will send you anything else for solving this problem.

Thanks in advance

Sabian

Attachment: SfDataGrid_Summary_0.00_2c72d523.zip

[Sweatha Bharathi]

Hi Sabian Sirius ,

We have reviewed your query. Based on the details you provided, we prepared a sample to replicate the reported scenario. However, we were unable to reproduce the issue on our end. The CaptionSummaryRow sum value displays properly value 0.00 in .NET 8, it is working fine as expected.

We have attached the sample and image for your reference. Kindly review it. To assist you further, we request the following additional details about your scenario:

Customizations:  Have you done any customization for DataGrid ? Additionally, share the details about the property type and values that used for CaptionSummary calculation?

Modified Sample: Please modify the attached sample to reproduce the issue on your end and share the updated version with us. If possible provide the video reference.

Providing these details will help us better understand the issue and offer a more accurate and effective solution.

Image Reference:

Regards,

Sweatha B

Attachment: SfDataGridDemo_43a8fda3.zip

[Sabian Sirius]

Hi Sweatha B,

I run your sample. It works fine. I think that maybe it has something with reading data from SQL Server via Stored procedure or View.

From my point of view my code looks the same. I did some customizations, and I don't know which parameter causing the problem. It is interesting that when I change the order of column "Konto" (Descending) so the first value of Saldo now is greater then 0, result of Caption Summary Row shows "0.00" as it should be. When I back order to Ascending it shows "-0.00". I am using Serbian Language settings.

Descending

Would you like to send you my whole project and database?

Thanks in advance.

Sabian S

Attachment: Caption_Summary_Row__Change_order_7e73e7b7.zip

[Sabian Sirius]

Hi Sweatha B,

I run your sample. It works fine. I think that maybe it has something with reading data from SQL Server via Stored procedure or View.

From my point of view my code looks the same. I did some customizations, and I don't know which parameter causing the problem. It is interesting that when I change the order of column "Konto" (Descending) so the first value of Saldo now is greater then 0, result of Caption Summary Row shows "0.00" as it should be. When I back order to Ascending it shows "-0.00". I am using Serbian Language settings.

Descending

Would you like to send you my whole project and database?

Thanks in advance.

Sabian S

[Sweatha Bharathi]

Sabian Sirius ,

We have reviewed your query. Based on the information you provided, we understand that you are using the Serbian language. We enabled the Serbian language using culture settings and tested the scenario; however, we were not able to replicate the issue. The value is correctly returned as 0,00 in the Serbian culture.

We have attached a sample for your reference. Kindly review and modify the sample to replicate your scenario. To assist further, please provide the following details:

1. Any specific customizations made to the CaptionSummaryRow in your application that differ from our provided sample
2. Kindly share the details about the property type and values that used for CaptionSummary calculation?

Note: The issue is unlikely to be caused by the data retrieve from database or culture settings directly. It may be related to the value or custom logic applied to the CaptionSummaryRow. There is no need to share the database and sample. Provide only the requested details.

Attachment: SfDataGridDemo_ee59261.zip