DataTemplate for GridSummaryColumn in WPF

[Eric BIEF]

Is it a way to use DataTemplate for GridSummaryColumn in WPF ?

Something like :

<syncfusion:GridSummaryColumn

                                        Name="SummaryExecutedQuantity"

                                        Format="'{Sum:n0}'"

                                        MappingName="ExecutedQuantity"

                                        SummaryType="DoubleAggregate">

                                        <syncfusion:GridSummaryColumn.Template>

                                            <DataTemplate>

                                                <TextBlock

                                                    HorizontalAlignment="Center"

                                                    VerticalAlignment="Center"

                                                    FontSize="10"

                                                    Text="{Binding Path=SummaryExecutedQuantity}" />

                                            </DataTemplate>

                                        </syncfusion:GridSummaryColumn.Template>

                                    </syncfusion:GridSummaryColumn>

If yes could give me an example.

Thanks

Eric

[Saravanan Ayyanar]

Hi Eric, 

 

Thank you for using Syncfusion controls. 

 

We have checked your reported scenario. You are tried correct way to use DataTemplate for GridSummaryColumn in WPF. Please refer the sample link below, 

 

Sample Link: 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/TableSummary838445066 

 

UG Link: 

https://help.syncfusion.com/wpf/datagrid/summaries?cs-save-lang=1&cs-lang=csharp#table-summary-template 

 

Please let us know, if you require further assistance on this. 

 

Regards, 

Saravanan A. 

[DanielPa]

Hi,

is there always the need of a converter when using a DataTemplate?  

I only need a solution to keep the text prefix for Count localizable.  

<syncfusion:GridSummaryColumn

                                                        Name="Location"

                                                        Format="SomeLocalizedTextNeededHere: {Count:d}'"

                                                        MappingName="Location"

                                                        SummaryType="CountAggregate"/>

Something like:

<syncfusion:GridSummaryColumn

                                                        Name="Location"

                                                        Format="'{Count:d}'"

                                                        MappingName="Location"

                                                        SummaryType="CountAggregate">

                                                        <syncfusion:GridSummaryColumn.Template>

                                                            <DataTemplate>

                                                                <TextBlock>

                                                                    <Run Text="{lex:Loc MyLocalizedTextVar}" />

                                                                    <Run Text="{Binding ??Count??}" />

                                                                </TextBlock>

                                                            </DataTemplate>

                                                        </syncfusion:GridSummaryColumn.Template>

                                                    </syncfusion:GridSummaryColumn>

[Vijayarasan Sivanandham]

Hi DanielPa,

Thanks for the update.

Yes. You need to use converter for DataTemplate using in GridSummaryColumn in SfDataGrid.

Please let us know, if you require further assistance on this.

Regards,
Vijayarasan S 

[DanielPa]

Thanks for response. So here is my solution. A lot of code, just for a localized prefix. Maybe you have some better ideas!?  

My ItemsSource is a List of "Item" with Id and GroupId as properties. The Grid is grouped by GroupId and AllowDataShaping is active, so the user can move Items to a Group by entering the GroupId. 

I use a single converter for a GroupSummaryColumn and two TableSummaryColumns:

public class SummaryColumnLocalizedPrefixConverter : IValueConverter

{

public object Convert(object value, Type targetType, object parameter, CultureInfo culture)

{

var summaryRecordEntry = value as SummaryRecordEntry;

if (summaryRecordEntry == null)

{

return string.Empty;

}

// GroupSummaryRow

if (summaryRecordEntry.Parent is Group parentGroup)

{

return $"{parameter}: {parentGroup.ItemsCount}";

}

// TableSummaryRow

if (summaryRecordEntry.Parent == null)

{

foreach (var summaryValue in summaryRecordEntry.SummaryValues)

{

if ((string)parameter == Properties.Resources.TotalItems &&

summaryValue.Name == nameof(Item.Id))

{

return $"{parameter}: {summaryValue.AggregateValues["Count"]}";

}

if ((string)parameter == Properties.Resources.TotalGroups &&

summaryValue.Name == nameof(Items.GroupId))

{

return $"{parameter}: {summaryValue.AggregateValues["GroupsCount"]}"; //custom Aggregate

}

}

}

return string.Empty;

}

public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)

{

throw new NotImplementedException();

}

}

The Xaml for the TableSummary Templates look like this

<syncfusion:SfDataGrid.TableSummaryRows>

<syncfusion:GridSummaryRow ShowSummaryInRow="False">

<syncfusion:GridSummaryRow.SummaryColumns>

<syncfusion:GridSummaryColumn Format="'{Count:d}'" MappingName="Id" SummaryType="CountAggregate">

<syncfusion:GridSummaryColumn.Template>

<DataTemplate>

<TextBlock Text="{Binding Converter={StaticResource SummaryColumnLocalizedPrefixConverter}, UpdateSourceTrigger=PropertyChanged, Mode=OneWay, ConverterParameter={lex:Loc TotalItems}}" />

</DataTemplate>

</syncfusion:GridSummaryColumn.Template>

</syncfusion:GridSummaryColumn>

<syncfusion:GridSummaryColumn CustomAggregate="{StaticResource GroupCountAggregate}" Format="'{GroupsCount:d}'" MappingName="GroupId" SummaryType="Custom">

<syncfusion:GridSummaryColumn.Template>

<DataTemplate>

<TextBlock Text="{Binding Converter={StaticResource SummaryColumnLocalizedPrefixConverter}, UpdateSourceTrigger=PropertyChanged, Mode=OneWay, ConverterParameter={lex:Loc TotalGroups}}" />

</DataTemplate>

</syncfusion:GridSummaryColumn.Template>

</syncfusion:GridSummaryColumn>

</syncfusion:GridSummaryRow.SummaryColumns>

</syncfusion:GridSummaryRow>

</syncfusion:SfDataGrid.TableSummaryRows>

Regards, 

Daniel 

[Vijayarasan Sivanandham]

Hi DanielPa,

Thanks for the update.

Based on provided information we have checked your provided code snippet from our side this is the best way to achieve your requirement “DataTemplate using in GridSummaryColumn” in SfDataGrid.

Regards,
Vijayarasan S