TableSummaryRow showing no information
<syncfusion:SfDataGrid Grid.Row="2" ItemsSource="{Binding Resources}" SelectedIndex="{Binding SelectedIndex}" SelectedItem="{Binding Selected}"
ColumnSizer="AutoWithLastColumnFill" AutoGenerateColumns="False" AllowDeleting="True">
<syncfusion:SfDataGrid.Columns>
<syncfusion:GridTextColumn HeaderText="{res:Translate Text=identifier}" DisplayBinding="{Binding ProductIdentifier}" MappingName="ProductIdentifier"/>
<syncfusion:GridTextColumn HeaderText="{res:Translate Text=amount}" DisplayBinding="{Binding Amount}" MappingName="Amount"/>
<syncfusion:GridTextColumn HeaderText="{res:Translate Text=unitprice}" DisplayBinding="{Binding PricePerUnit}"/>
<syncfusion:GridTextColumn HeaderText="{res:Translate Text=price}" DisplayBinding="{Binding Price}" MappingName="Price"/>
<syncfusion:GridTextColumn HeaderText="{res:Translate Text=note}" DisplayBinding="{Binding Note}"/>
</syncfusion:SfDataGrid.Columns>
<syncfusion:SfDataGrid.DetailsViewDefinition>
<syncfusion:TemplateViewDefinition >
<syncfusion:TemplateViewDefinition.RowTemplate>
<DataTemplate >
<ContentPresenter Content="{Binding Data}" ContentTemplate="{DynamicResource purchasedetailtemplate}"/>
</DataTemplate>
</syncfusion:TemplateViewDefinition.RowTemplate>
</syncfusion:TemplateViewDefinition>
</syncfusion:SfDataGrid.DetailsViewDefinition>
<syncfusion:SfDataGrid.TableSummaryRows>
<syncfusion:GridTableSummaryRow ShowSummaryInRow="True">
<syncfusion:GridTableSummaryRow.SummaryColumns>
<syncfusion:GridSummaryColumn Name="EntriesCount" Format="'Total Count: {Count:d}'" MappingName="ProductIdentifier" SummaryType="CountAggregate" />
<syncfusion:GridSummaryColumn Name="TotalAmount" Format="'Total Amount: {Sum:c}'" MappingName="Amount" SummaryType="DoubleAggregate" />
<syncfusion:GridSummaryColumn Name="TotalPrice" Format="'Total Price: {Sum:c}'" MappingName="Price" SummaryType="DoubleAggregate" />
</syncfusion:GridTableSummaryRow.SummaryColumns>
</syncfusion:GridTableSummaryRow>
</syncfusion:SfDataGrid.TableSummaryRows>
</syncfusion:SfDataGrid>
why i dont see any information with this code?
Hi Klaus Aman,
Thank you for sharing the code snippet.
We reviewed the code snippet and noticed that you set the ShowSummaryInRow property to true, but did not set the Title. To display the summary values in the table summary row when ShowSummaryInRow is set to true, you need to provide a GridSummaryRow.Title based on the GridSummaryColumn.Name property to format the summary column values in the row. Please find the code snippet below:
Code snippet:
<syncfusion:SfDataGrid.TableSummaryRows> <syncfusion:GridTableSummaryRow ShowSummaryInRow="True" Title=" Total EntriesCount : {EntriesCount} with Total amount {TotalAmount} and Total price {TotalPrice} " > <syncfusion:GridTableSummaryRow.SummaryColumns> <syncfusion:GridSummaryColumn Name="EntriesCount" Format="'Total Count: {Count:d}'" MappingName="OrderID" SummaryType="CountAggregate" /> <syncfusion:GridSummaryColumn Name="TotalAmount" Format="'Total Amount: {Sum:c}'" MappingName="Amount" SummaryType="DoubleAggregate" /> <syncfusion:GridSummaryColumn Name="TotalPrice" Format="'Total Price: {Sum:c}'" MappingName="Price" SummaryType="DoubleAggregate" /> </syncfusion:GridTableSummaryRow.SummaryColumns> </syncfusion:GridTableSummaryRow> </syncfusion:SfDataGrid.TableSummaryRows> |
We have prepared a sample with this modification, which you can find in the attachment.
Output:
Please refer to the user guide documentation regarding the GridSummaryRow.Title with the ShowSummaryInRow property.
UG: https://help.syncfusion.com/wpf/datagrid/summaries#displaying-summary-for-row
For more information about Table Summary, please refer to the user guide documentation linked below.
UG: https://help.syncfusion.com/wpf/datagrid/summaries#table-summary
If you have any concerns regarding this, please feel free to ask; we are happy to assist you.
Regards,
Sreemon Premkumar M.
Attachment: SfDataGrid_TableSummary_Demo_3c573f7b.zip
- 1 Reply
- 2 Participants
-
KA Klaus Aman
- Aug 14, 2024 04:21 PM UTC
- Aug 15, 2024 02:09 PM UTC