Summary rows doesn't work with filtered virtual rows

[Özgür ALTUNSÖGÜT]

Hello,

We have created an example project that has a data grid virtual row and filtering is enabled. Imagine that there are two columns which are product and amount.

Amount column has a summary row. When we filter a product, the summary row doesn't refresh.

Could you please send an example about this issue.

Best regards.

[Jeevakanth Palaniappan]

Hi Ozgur, 

Greetings from Syncfusion support. 

We have checked your query and we would like to inform you that by default the aggregate will not be refreshed on performing filtering. You can only achieve it by using the custom aggregate feature of thr grid. Based on your requirement, we have prepared a sample. Please find the below code snippet and the sample for your reference. 

<SfGrid @ref="Grid" DataSource="@GridData" Height="600" EnableVirtualization="true" AllowFiltering="true"> 

    <GridEvents TValue="Order" OnActionComplete="ActionComplete"></GridEvents> 

    <GridAggregates> 

        <GridAggregate> 

            <GridAggregateColumns> 

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

                    <FooterTemplate> 

                        @{ 

                            <div> 

                                <p>Sum: @GetSumAggregate()</p> 

                            </div> 

                        } 

                    </FooterTemplate> 

                </GridAggregateColumn> 

            </GridAggregateColumns> 

        </GridAggregate> 

    </GridAggregates> 

    <GridColumns> 

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

    </GridColumns> 

</SfGrid> 

 

@code{ 

    public static List<Order> GridData { get; set; } 

    SfGrid<Order> Grid { get; set; } 

    List<Order> FilteredRecords = GridData; 

    public async Task ActionComplete(ActionEventArgs<Order> args) { 

        if (args.RequestType == Syncfusion.Blazor.Grids.Action.Filtering) { 

            FilteredRecords = (await Grid.GetFilteredRecords()) as List<Order>; 

        } else if (args.RequestType == Syncfusion.Blazor.Grids.Action.ClearFiltering) { 

            FilteredRecords = GridData; 

        } 

    } 

    public string GetSumAggregate() { 

        return (FilteredRecords.Sum(x=>x.Freight)).ToString(); 

    } 

} 

Sample - https://www.syncfusion.com/downloads/support/directtrac/general/ze/Grouping-2065881884 

Documentation - https://blazor.syncfusion.com/documentation/datagrid/aggregates/#custom-aggregate 

Please get back to us if you have any other queries. 

Regards, 

Jeevakanth SP. 

[Özgür ALTUNSÖGÜT]

Hello,

By default, if virtual row is not enabled, aggregate function works as aspected. But if you enable virtual row, after filtering summary rows not refresh.

We have solved this to disable virtual row property in onActionComplete event and reactivate after event completed.

The problem is solved for us. Thank you.

[Jeevakanth Palaniappan]

Hi Ozgur, 

 

Thanks for the update. We are glad that the reported problem is resolved at your end. Please get back to us if you have any other queries. 

Regards, 

Jeevakanth SP.