I want to display Sub TotalAmount instead of SUM

[Belle Cruz]

I want to display the word Sub TotalAmount instead of Sum

[Dhivyabharathi Mohan]

Hi Belle, 

 

Thank you for contacting Syncfusion support. 

 

Before we validate and proceed further, we would like to know the below details as we are not clear with the provided information.  

1. Please confirm if you are trying to export from DataGrid to PDF. If no, kindly share the Syncfusion Component detail from which you are exporting to PDF. 
2. Also, share the Syncfusion package details with the version.

This will be helpful to investigate further and provide the solution at the earliest. 

 

Regards, 

Dhivya. 

[Ashley Grey]

Good afternoon. I am trying to export Datagrid to PDF. and when exported I want to display the Sub TotalAmount instead of Sum.

[Vignesh Natarajan]

Hi Belle,  

 

Thanks for the confirmation.  

 

Query: “I am trying to export Datagrid to PDF. and when exported I want to display the Sub TotalAmount instead of Sum.” 

 

We have validated query your requirement and we suggest you to achieve your requirement using PdfAggregateTemplateInfo event of Grid. This event will be triggered when aggregate data value is exported to pdf cell. Here we suggest you to change the cell value to prefix “TotalAmount”.  

 

Refer the below code example. 

 

<SfGrid ID="Grid" @ref="DefaultGrid" DataSource="@Orders" AllowGrouping="true" Toolbar="@(new List<string>() { "PdfExport" })" AllowPdfExport="true"> 

    <GridGroupSettings Columns="@Initial"></GridGroupSettings> 

    <GridEvents OnToolbarClick="ToolbarClickHandler" PdfAggregateTemplateInfo="AggregateTemplate" TValue="Order"></GridEvents> 

    <GridAggregates> 

        <GridAggregate> 

            <GridAggregateColumns> 

                <GridAggregateColumn Field=@nameof(Order.Freight) Type="AggregateType.Sum" Format="N2"> 

                    <GroupCaptionTemplate> 

                        @{ 

                            var aggregate = (context as AggregateTemplateContext); 

                            <div> 

                                <p>TotalAmount: @aggregate.Sum</p> 

                            </div> 

                        } 

                    </GroupCaptionTemplate> 

                </GridAggregateColumn> 

            </GridAggregateColumns> 

        </GridAggregate> 

    </GridAggregates> 

    <GridColumns> 

        <GridColumn Field=@nameof(Order.OrderID) HeaderText="Order ID" TextAlign="TextAlign.Right" Width="120"></GridColumn> 

        <GridColumn Field=@nameof(Order.CustomerID) HeaderText="Customer Name" Width="150"></GridColumn> 

        <GridColumn Field=@nameof(Order.OrderDate) HeaderText=" Order Date" Format="d" Type="ColumnType.Date" TextAlign="TextAlign.Right" Width="130"></GridColumn> 

        <GridColumn Field=@nameof(Order.Freight) HeaderText="Freight" Format="C2" TextAlign="TextAlign.Right" Width="120"></GridColumn> 

    </GridColumns> 

</SfGrid> 

  

@code{ 

    private SfGrid<Order> DefaultGrid; 

    public List<Order> Orders { get; set; } 

  

    public void AggregateTemplate(PdfAggregateEventArgs Args) 

    { 

        if (Args.Column.Field == "Freight") 

        { 

            Args.Cell.Value = "TotalAmount: "+ Args.Cell.Value; 

        } 

    } 

    public async Task ToolbarClickHandler(Syncfusion.Blazor.Navigations.ClickEventArgs args) 

    { 

        if (args.Item.Id == "Grid_pdfexport")  //Id is combination of Grid's ID and itemname 

        { 

            await this.DefaultGrid.PdfExport(); 

        } 

    } 

 

 

Kindly refer the below sample for your reference 

 

Sample: https://www.syncfusion.com/downloads/support/forum/170571/ze/DataGrid_Server-1301702276.zip 

 

Refer our UG documentation for your reference 

 

https://blazor.syncfusion.com/documentation/datagrid/events#pdfaggregatetemplateinfo 

 

Please get back to us if you have further queries.  

 

Regards, 

Vignesh Natarajan