Issue with allowGrouping="true" and showDropArea="true" and groupCaptionTemplate type Min/Max

[Massimo Giambona]

Info

OS: Windows 10

ASP.NET Core: 2.0.1

Syncfusion Web Essentia JS 2: 16.1.0.24

Step to reproduce:

1. allowGrouping="true"
2. showDropArea="true"
3. setup aggregate-columns with groupCaptionTemplate="${Max}"  type="Max" (or Min)

Expected result

A grouped grid with header and footer group

Actual behaviour

Empty Grid

Sample code

    

   

   

       

           

               

               

               

           

       

   

   

       

       

       

       

       

   

[Venkatesh Ayothi Raman]

Hi Massimo, 

 

Thanks for using Syncfusion products. 

 

We were unable to reproduce the reported issue at our end and we have prepared a sample for your convenience which can be download from following link, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/F136413_Sample-198792740 

 

Code example: 

[Grid] 

 

<ejs-grid id="Grid" dataSource="ViewBag.datasource" allowGrouping="true" allowPaging="true"> 

 

 

    <e-grid-aggregates> 

        <e-grid-aggregate> 

            <e-aggregate-columns> 

                <e-aggregate-column field="UnitsInStock" type="Sum" groupFooterTemplate="Total units: ${Sum}"></e-aggregate-column> 

                <e-aggregate-column field="Discontinued" type="Truecount" groupFooterTemplate="Discontinued: ${Truecount}"></e-aggregate-column> 

                <e-aggregate-column field="UnitsInStock" type="Max" groupCaptionTemplate="Maximum: ${Max}"></e-aggregate-column> 

 

            </e-aggregate-columns> 

        </e-grid-aggregate> 

 

    </e-grid-aggregates> 

    <e-grid-groupsettings showDropArea="true" columns="@(new string[] { "CategoryName"})"></e-grid-groupsettings> 

    <e-grid-pagesettings pageCount="5"></e-grid-pagesettings> 

    <e-grid-columns> 

        . .  . 

    </e-grid-columns> 

 

 

</ejs-grid> 

 

Help documentation: https://ej2.syncfusion.com/16.1.24/aspnet/documentation/grid/aggregates.html?syntax=tag#group-and-caption-aggregate 

https://ej2.syncfusion.com/16.1.24/aspnet/documentation/grid/getting-started-core.html?syntax=tag 

 

Online Demo: https://aspdotnetcore.syncfusion.com/Grid/GroupAndCaptionAggregate#/material 

 

If you still face the same issue then could you please provide following details? 

1)      We didn’t find the code example in your last update. 

2)       Any error or exception was thrown while running the project? If so, share the details. 

3)      Please confirm whether you are referred the Script and CSS file in _Layout.html file. 

4)      Please confirm whether you are defined the “ejs-scripts” script manager in _Layout.html file. 

 

It would be helpful for us to find the problem and provide the solution as earliest. 

 

Regards, 

Venkatesh Ayothiraman. 

[Massimo Giambona]

Hi,

Thanks for your reply.

See the attached zip where I'm able to repro the bug.

Please note that is a ASP.NET Core  .NET Framework (NOT .NET Core) application

Application

.Net Framework - ASP.NET Core 2.0 

Attachment: WebApplicationGridBug_919ceff6.zip

[Venkatesh Ayothi Raman]

Hi Massimo, 

Thanks for the update. 

We went through your sample which you have share for us and found that AmountSw field has some null values. So, if we are grouping the Year column then all AmountSw values are null which is under the KeyValue Year:2018. This is the cause of this issue and we have considered this “Aggregates returns undefined value while we define the null values in Datasource” as bug and logged the defect report. This fix will be included in our Upcoming patch release on March 28,2018. 

Until we appreciate your patience. 

Regards, 

Venkatesh Ayothiraman.