Having difficulty find soltuions for probably common issues

[Johan]

Hi,

Thanks for your quick answers on my previous questions. I'm thinking that I missed some kind of FAQ section of this forum. Please point me in the right direction.

What I'm trying to find:

- How to add a 'calculated column' to a datagrid. (like the difference between two columns, displayed in a third column)

- How to filter on a date (without time), while the column type is DateTime (including time).

- How to add summaries of columns under a filtered grid.

Thank you for guiding me, and thanks again for your great product and great service !

Best, Johan

[Renjith Singh Rajendran]

Hi Johan, 

Greetings from Syncfusion support. 

We have prepared a consolidated sample based on the below three queries for your convenience, please download the sample from the link below, 

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

 

Query 1 : - How to add a 'calculated column' to a datagrid. 

We suggest you to use ColumnTemplate feature of Grid. With this you can display a customized column in Grid. 

Reference : https://blazor.syncfusion.com/documentation/datagrid/columns/#column-template 

 

In the below code, we have calculated difference between A and B column, and display in 3^rd column. Please refer the codes below, 

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

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

<GridColumn HeaderText="Diff of A&B" Format="C2" TextAlign="TextAlign.Right" Width="120"> 

    <Template> 

        @{ 

            var a = context as Order; 

            var Difference = a.A - a.B; 

        } 

        <span>@Difference</span> 

    </Template> 

</GridColumn> 

 

 

Query 2 : How to filter on a date (without time), while the column type is DateTime (including time). 

We suggest you to refer the below documentation for more details regarding filtering columns in grid. In the above attached sample we have performed filtering for a DateTime(values including time) column. 

Reference : https://blazor.syncfusion.com/documentation/datagrid/filtering/ 

Query 3 : - How to add summaries of columns under a filtered grid. 

We suggest you to refer the below documentation for more details regarding aggregate columns in Grid. In the above attached sample we have added summary to the OrderDate column. 

Reference : https://blazor.syncfusion.com/documentation/datagrid/aggregates/ 

Please get back to us if you need further assistance. 

Regards, 

Renjith Singh Rajendran 

[Padmini Ramamurthy]

From: Johan Jongsma
Sent: Thursday, April 1, 2021 10:07 AM
To: Syncfusion Support <[email protected]>
Subject: Re: Syncfusion support community forum 164060, Having difficulty find soltuions for probably common issues, has been updated. 

  

Hi Renjith, 

 

I cannot believe how great your support is. You delivered me a working example with all my issues in a working demo-app. Amazing !!! 

 

All the best, Johan 

 

ps. I cannot post this message on the support forum; for some reason it does not let me click the CAPTCHA button... 

[Renjith Singh Rajendran]

Hi Johan, 

Thanks for your update. We are glad to hear your requirement is achieved. 

Please get back to us if you need further assistance. 

Regards, 

Renjith R