Summary row is not updating when i add/remove a new row
My dataGrid has a ObservableCollection as data source.
When i add a new item into collection, the total values in summary row does not updated!
There is screenshot in attach file.
My sfDataGrid :
<syncfusion:SfDataGrid Grid.Row="1"
x:Name="MainSfDataGrid"
ItemsSource="{Binding Path=TemporaryCollection,Mode=TwoWay}"
AllowGrouping="False" AllowResizingColumns="True" AllowRowHoverHighlighting="True"
AllowSelectionOnPointerPressed="True"
BorderBrush="{DynamicResource LightBlueAccentBrush}" AutoGenerateColumns="False"
RowHoverHighlightingBrush="{StaticResource LightOverlayBlueAccentBrush}"
Background="Transparent"
SelectedItem="{Binding Path=SelectedItem,Mode=TwoWay}">
<syncfusion:SfDataGrid.Resources>
<Style TargetType="syncfusion:GridHeaderCellControl">
<Setter Property="Foreground" Value="White" />
<Setter Property="Background" Value="{DynamicResource LightBlueAccentBrush}" />
</Style>
</syncfusion:SfDataGrid.Resources>
<syncfusion:SfDataGrid.Columns>
<syncfusion:GridNumericColumn HeaderText="№" MappingName="RowNumber" NumberDecimalDigits="0"
ColumnSizer="Auto" />
<syncfusion:GridNumericColumn HeaderText="Article" MappingName="Article" NumberDecimalDigits="0"
ColumnSizer="Auto" />
<syncfusion:GridTextColumn HeaderText="Title" MappingName="Title" ColumnSizer="Star" />
<syncfusion:GridTextColumn HeaderText="Description" MappingName="Description" ColumnSizer="Star" />
<syncfusion:GridNumericColumn HeaderText="Quantity" MappingName="Quantity" NumberDecimalDigits="2"
ColumnSizer="Auto" />
<syncfusion:GridNumericColumn HeaderText="Price" MappingName="Price" NumberDecimalDigits="2"
ColumnSizer="Auto" />
<syncfusion:GridNumericColumn HeaderText="Summ" MappingName="Sum" NumberDecimalDigits="2"
ColumnSizer="Auto" />
</syncfusion:SfDataGrid.Columns>
<syncfusion:SfDataGrid.TableSummaryRows>
<syncfusion:GridTableSummaryRow Title="Summary: {TotalSum} , {TotalQuantity} names." ShowSummaryInRow="True">
<syncfusion:GridTableSummaryRow.SummaryColumns>
<syncfusion:GridSummaryColumn Name="TotalSum"
Format="'{Sum:c}'"
MappingName="Sum"
SummaryType="DoubleAggregate" />
<syncfusion:GridSummaryColumn Name="TotalQuantity"
MappingName="RowNumber"
Format="'{Count:d}'"
SummaryType="CountAggregate" />
</syncfusion:GridTableSummaryRow.SummaryColumns>
</syncfusion:GridTableSummaryRow>
</syncfusion:SfDataGrid.TableSummaryRows>
</syncfusion:SfDataGrid>
Attachment: Screenshot_4_aacbd77a.rar
When i add a new item into collection, the total values in summary row does not updated!
There is screenshot in attach file.
My sfDataGrid :
<syncfusion:SfDataGrid Grid.Row="1"
x:Name="MainSfDataGrid"
ItemsSource="{Binding Path=TemporaryCollection,Mode=TwoWay}"
AllowGrouping="False" AllowResizingColumns="True" AllowRowHoverHighlighting="True"
AllowSelectionOnPointerPressed="True"
BorderBrush="{DynamicResource LightBlueAccentBrush}" AutoGenerateColumns="False"
RowHoverHighlightingBrush="{StaticResource LightOverlayBlueAccentBrush}"
Background="Transparent"
SelectedItem="{Binding Path=SelectedItem,Mode=TwoWay}">
<syncfusion:SfDataGrid.Resources>
<Style TargetType="syncfusion:GridHeaderCellControl">
<Setter Property="Foreground" Value="White" />
<Setter Property="Background" Value="{DynamicResource LightBlueAccentBrush}" />
</Style>
</syncfusion:SfDataGrid.Resources>
<syncfusion:SfDataGrid.Columns>
<syncfusion:GridNumericColumn HeaderText="№" MappingName="RowNumber" NumberDecimalDigits="0"
ColumnSizer="Auto" />
<syncfusion:GridNumericColumn HeaderText="Article" MappingName="Article" NumberDecimalDigits="0"
ColumnSizer="Auto" />
<syncfusion:GridTextColumn HeaderText="Title" MappingName="Title" ColumnSizer="Star" />
<syncfusion:GridTextColumn HeaderText="Description" MappingName="Description" ColumnSizer="Star" />
<syncfusion:GridNumericColumn HeaderText="Quantity" MappingName="Quantity" NumberDecimalDigits="2"
ColumnSizer="Auto" />
<syncfusion:GridNumericColumn HeaderText="Price" MappingName="Price" NumberDecimalDigits="2"
ColumnSizer="Auto" />
<syncfusion:GridNumericColumn HeaderText="Summ" MappingName="Sum" NumberDecimalDigits="2"
ColumnSizer="Auto" />
</syncfusion:SfDataGrid.Columns>
<syncfusion:SfDataGrid.TableSummaryRows>
<syncfusion:GridTableSummaryRow Title="Summary: {TotalSum} , {TotalQuantity} names." ShowSummaryInRow="True">
<syncfusion:GridTableSummaryRow.SummaryColumns>
<syncfusion:GridSummaryColumn Name="TotalSum"
Format="'{Sum:c}'"
MappingName="Sum"
SummaryType="DoubleAggregate" />
<syncfusion:GridSummaryColumn Name="TotalQuantity"
MappingName="RowNumber"
Format="'{Count:d}'"
SummaryType="CountAggregate" />
</syncfusion:GridTableSummaryRow.SummaryColumns>
</syncfusion:GridTableSummaryRow>
</syncfusion:SfDataGrid.TableSummaryRows>
</syncfusion:SfDataGrid>
Attachment: Screenshot_4_aacbd77a.rar
SIGN IN To post a reply.
3 Replies
SR
Sivakumar R
Syncfusion Team
January 5, 2016 03:27 PM UTC
Hi Mikhail,
Based on the code snippet provides, set SfDataGrid.LiveDataUpdateMode property value to AllowSummaryUpdate or AllowDataShaping.
https://help.syncfusion.com/wpf/sfdatagrid/data-manipulation
Please let us know if you have any questions.
Thanks,
Sivakumar
Based on the code snippet provides, set SfDataGrid.LiveDataUpdateMode property value to AllowSummaryUpdate or AllowDataShaping.
https://help.syncfusion.com/wpf/sfdatagrid/data-manipulation
Please let us know if you have any questions.
Thanks,
Sivakumar
MI
Mikhail
January 6, 2016 08:02 AM UTC
Thanks for your advice, I set the property SfDataGrid.LiveDataUpdateMode to AllowSummaryUpdate , and now the summary row works correct!
SP
Sowndaiyan Paulpandi
Syncfusion Team
January 7, 2016 03:56 AM UTC
Hi Mikhail,
Thanks for the update.
Please let us know if you need further assistance.
Regards,
Sowndaiyan
Thanks for the update.
Please let us know if you need further assistance.
Regards,
Sowndaiyan
SIGN IN To post a reply.
- 3 Replies
- 3 Participants
-
MI Mikhail
- Jan 5, 2016 03:19 PM UTC
- Jan 7, 2016 03:56 AM UTC