sfdatagrid GridTableSummaryRow always 0

[renruofan]

This is what source look like: 

<syncfusion:SfDataGrid Name="DataGrid1" Grid.Row="1" Style="{StaticResource SfDataGridStyleBase}"
                               RowStyle="{StaticResource SfDataGridRowStyleBase}">
            <syncfusion:SfDataGrid.TableSummaryRows>
                <syncfusion:GridTableSummaryRow ShowSummaryInRow="False" Position="Bottom">
                    <syncfusion:GridSummaryRow.SummaryColumns>
                        <syncfusion:GridSummaryColumn Name="Sum"
                                        Format="{Count:d}"
                                        MappingName="Id"
                                        SummaryType="CountAggregate" />
                    syncfusion:GridSummaryRow.SummaryColumns>
                syncfusion:GridTableSummaryRow>
            syncfusion:SfDataGrid.TableSummaryRows>
 
            <syncfusion:SfDataGrid.Columns>
                <syncfusion:GridTemplateColumn AllowSorting="False" AllowFiltering="False" Width="60">
                    <syncfusion:GridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <Button Content="Cancel" Command="{Binding UserInfoVM.CancelChangedCommand,Source={StaticResource Locator}}" Margin="1" />
                        DataTemplate>
                    syncfusion:GridTemplateColumn.CellTemplate>
                syncfusion:GridTemplateColumn>
                <syncfusion:GridTextColumn HeaderText="ID" DisplayBinding="{Binding Id}" />
                <syncfusion:GridTextColumn HeaderText="Name" DisplayBinding="{Binding Name}" />
                <syncfusion:GridTextColumn HeaderText="State" DisplayBinding="{Binding State,Converter={StaticResource MyModelStatusConverter},UpdateSourceTrigger=PropertyChanged}" />
            syncfusion:SfDataGrid.Columns>
        syncfusion:SfDataGrid>

Thank you.

[Jai Ganesh S]

Hi Renruofan, 

We have checked your code snippet and in that you have wrongly set the format for TableSummary.  

<syncfusion:GridTableSummaryRow ShowSummaryInRow="False" Position="Bottom"> 

                    <syncfusion:GridSummaryRow.SummaryColumns> 

                        <syncfusion:GridSummaryColumn Name="Sum" 

                                        Format="{Count:d}" 

                                        MappingName="Id" 

                                        SummaryType="CountAggregate" /> 

                    <syncfusion:GridSummaryRow.SummaryColumns> 

                <syncfusion:GridTableSummaryRow> 

 <syncfusion:SfDataGrid.TableSummaryRows> 

 

 

You have to set the format for the TableSummaryColumn like below, 

<syncfusion:GridTableSummaryRow Position="Bottom" ShowSummaryInRow="False"> 

                        <syncfusion:GridTableSummaryRow.SummaryColumns> 

                            <syncfusion:GridSummaryColumn Name="Sum" 

                                                          Format="'{Count:d}'" 

                                                          MappingName="QS1" 

                                                          SummaryType="CountAggregate" /> 

                            

                        </syncfusion:GridTableSummaryRow.SummaryColumns> 

</syncfusion:GridTableSummaryRow> 

 

Please refer the below UG documentation to know more details on Table Summary. 

UG Link: https://help.syncfusion.com/wpf/sfdatagrid/summaries?cs-save-lang=1&cs-lang=xaml#defining-summary-for-column  

Please let us know if you have any further questions.

Regards,
Jai Ganesh S 

[renruofan]

Thank you for your reply.

I've modify my source, but it still not work.

What are the possible problems?

BTW:I'm using MVVMLight frame.

[Jai Ganesh S]

Hi Renruofan, 

 

We have prepared a sample for using MVVMLight frame but we are unable to reproduce the issue and the Table Summary row shows correctly in our end. 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/SfDataGridMVVMLight1927803847.zip 

 

Could you please check the above sample and if you are still facing the issue then please modify the above sample to replicate the issue. This would be more helpful for us to proceed further. 

Regards, 

Jai Ganesh S

[renruofan]

Thank you for your reply.

According to your demo, I've found the problem actually.

In constructed function, there is no problem.After I clear the collection, and add new item into the collection, the summary row is not work.

I've uploaded demo in this reply.

Thank you.

Attachment: SfDataGridMVVMLight_Changed_f9b2638a.rar

[Jai Ganesh S]

Hi Renruofan, 

 

You can achieve your requirement for updating the GridTableSummaryRow total while adding a new record in a collection by setting the LiveDataUpdateMode as AllowSummaryUpdate in SfDataGrid,  

  

<Syncfusion:SfDataGrid Margin="10" Name="MyDataGrid" 

                  ItemsSource="{Binding GDCSource}"  

                  ColumnSizer="Star"  

                  AutoGenerateColumns="False"  

                  LiveDataUpdateMode="AllowSummaryUpdate" 

                  /> 

  

https://help.syncfusion.com/wpf/sfdatagrid/data-manipulation#livedataupdatemode--allowsummaryupdate  

  

Regards,  

Jai Ganesh S

[renruofan]

After I add LiveDataUpdateMode="AllowSummaryUpdate" , it worked!

Thank you!

You help me a lot.

[Jai Ganesh S]

Hi Renruofan,  

 

Thank you for the update. 

 

Please let us know if you need further assistance on this. 

 

Regards, 

Jai Ganesh S