SfDataGrid Summary with Template

[David]

Good morning, I have a summary and I would like to be able to format it, align it to the right, etc. I tried to use the new GridTableSummaryCellRendererExt () but in sfLabel it always came null and the application crashed. Is there any way to add a template at the moment I add the summary? And if it is possible, what value can I put the label Text so that the summary appears?

[Karthikraja Kalaimani]

Hi David,

Please refer to the below code snippet for the CaptionSummaryTemplate. For more details please refer to the attached sample.

Code snippet :  

    <ContentPage.BindingContext> 

        <local:ViewModel x:Name="viewModel"/> 

    </ContentPage.BindingContext> 

    <ContentPage.Resources> 

        <local:GroupSummaryConverter x:Key="SummaryConverter"></local:GroupSummaryConverter> 

    </ContentPage.Resources> 

    <ContentPage.Content> 

        <sfgrid:SfDataGrid x:Name="dataGrid"  

                                        AllowEditing="False" 

                                        SelectionMode="Multiple"   

                                        NavigationMode="Cell" 

                                        AutoGenerateColumns="False" 

                                        ColumnSizer="None" 

                                        ItemsSource="{Binding OrdersInfo}" 

                                        ShowRowHeader="True" 

                                        AllowDraggingColumn="True" 

                                        EnableDataVirtualization="True" 

                                        NotificationSubscriptionMode ="None" 

                                        VerticalOverScrollMode="None" 

                                        VerticalOptions="FillAndExpand" 

                                        AlternationCount="5" 

                                        FrozenColumnsCount="2"> 

            <sfgrid:SfDataGrid.CaptionSummaryTemplate> 

                <DataTemplate> 

                    <StackLayout Orientation="Horizontal" BackgroundColor="Gray"> 

                        <Label Text="{Binding Converter={StaticResource SummaryConverter}, ConverterParameter = {x:Reference dataGrid} }" 

              TextColor="White" 

              FontSize="Large" 

              HorizontalTextAlignment="End" 

              LineBreakMode="NoWrap" 

              HorizontalOptions="FillAndExpand" 

              VerticalOptions="FillAndExpand"> 

                            <Label.Style> 

                                <Style TargetType="Label"> 

                                    <Setter Property="FontAttributes" Value="Bold, Italic" /> 

                                </Style> 

                            </Label.Style> 

                        </Label> 

                    </StackLayout> 

                </DataTemplate> 

            </sfgrid:SfDataGrid.CaptionSummaryTemplate> 

            <sfgrid:SfDataGrid.CaptionSummaryRow> 

                <sfgrid:GridSummaryRow Name="CaptionSummary" ShowSummaryInRow="True" Title=""> 

                    <sfgrid:GridSummaryRow.SummaryColumns> 

                        <sfgrid:GridSummaryColumn Name="CaptionSummary" 

                                      Format="{}{Sum}" 

                                      MappingName="OrderID" 

                                      SummaryType="DoubleAggregate" /> 

                    </sfgrid:GridSummaryRow.SummaryColumns> 

                </sfgrid:GridSummaryRow> 

            </sfgrid:SfDataGrid.CaptionSummaryRow> 

            <sfgrid:SfDataGrid.GroupColumnDescriptions> 

                <sfgrid:GroupColumnDescription ColumnName="OrderID"></sfgrid:GroupColumnDescription> 

            </sfgrid:SfDataGrid.GroupColumnDescriptions> 

            <sfgrid:SfDataGrid.Columns> 

                <sfgrid:GridNumericColumn MappingName="OrderID"></sfgrid:GridNumericColumn> 

                <sfgrid:GridNumericColumn MappingName="OrderID2"></sfgrid:GridNumericColumn> 

                <sfgrid:GridNumericColumn MappingName="EmployeeID"></sfgrid:GridNumericColumn> 

                <sfgrid:GridNumericColumn MappingName="CustomerID"></sfgrid:GridNumericColumn> 

                <sfgrid:GridTextColumn MappingName="FirstName"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="LastName"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="Gender"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="ShipCity"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="ShipCountry"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="Freight"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="Enabled"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="IsClosed"></sfgrid:GridTextColumn> 

                <sfgrid:GridTextColumn MappingName="ShippingDate"></sfgrid:GridTextColumn> 

            </sfgrid:SfDataGrid.Columns> 

        </sfgrid:SfDataGrid> 

    </ContentPage.Content> 

Sample link : https://www.syncfusion.com/downloads/support/directtrac/general/ze/DataGridSample1305886014.zip


Regards,
Karthik Raja