Grid not showing caption summary

Hello, I have a grid with grouped columns, but the caption summary isn't showing, I don't not what i'm doing wrong.
This is my grid code:

<ej-grid id="DetailsGrid" allow-filtering="true" allow-paging="true" datasource="ViewBag.ListPortfolioHeader" allow-grouping="true" create="onCreateGrid"
             locale="@(System.Globalization.CultureInfo.CurrentCulture.Name.ToString())" allow-selection="false" allow-sorting="true">
        <e-filter-settings filter-type="Excel" />
        <e-group-settings caption-format="{{:key}}" show-drop-area="false" show-grouped-column="false" grouped-columns="GroupedCols"></e-group-settings>
        <e-columns>
            <e-column field="PortfolioAssociate.IdPortfolio" header-text="IdPortfolio" visible="false"></e-column>
            <e-column field="PortfolioAssociate.Portfolio.ClientName" header-text="@Localizer["Description"].Value" text-align="Left"></e-column>
            <e-column field="PortfolioAssociate.Associate.Person.FullName" header-text="@Localizer["Associate"].Value" text-align="Left"></e-column>
            <e-column field="CommissionAmount" header-text="@Localizer["CommissionAmount"].Value" format="{0:N2}" text-align="Left"></e-column>
        </e-columns>

        <e-summary-rows>
            <e-summary-row title="Total" show-caption-summary="true">
                <e-summary-columns>
                    <e-summary-column summary-type="Sum" format="{0:N2}" display-column="CommissionAmount" datamember="CommissionAmount"/>
                </e-summary-columns>
            </e-summary-row>
        </e-summary-rows>

    </ej-grid>

@{
    var GroupedCols = new List<string>() { "PortfolioAssociate.IdPortfolio" };
}

and this is the result:


What's the problem?
Thanks

3 Replies 1 reply marked as answer

FS Farveen Sulthana Thameeztheen Basha Syncfusion Team July 14, 2020 01:55 PM UTC

Hi Neider, 

Thanks for contacting Syncfusion Support. 

Query#:- Hello, I have a grid with grouped columns, but the caption summary isn't showing 
 
We are able to replicate the problem while using your code example. To show summary rows, first step we need to enable is show-summary property in Grid model which is missed in your sample code.  

In order to avoid your reported problem we suggest you to enable show-summary in Grid and along with that to show summaries in each Group’s caption row, particular summary row should have the show-total-summary as false  
 
Refer to the code example:- 
@{ 
            var GroupedCols = new List<string>() { "EmployeeID" }; 
        } 
        <ej-grid id="DetailsGrid" allow-filtering="true" allow-paging="true" show-summary="true" datasource="ViewBag.DataSource" allow-grouping="true" create="onCreateGrid" 
                 locale="@(System.Globalization.CultureInfo.CurrentCulture.Name.ToString())" allow-selection="false" allow-sorting="true"> 
            <e-filter-settings filter-type="Excel" /> 
            <e-group-settings caption-format="{{:key}}" show-drop-area="false" show-grouped-column="false" grouped-columns="GroupedCols"></e-group-settings> 
            <e-columns> 
                <e-column field="EmployeeID" header-text="IdPortfolio" visible="false"></e-column> 
                .     .     .  
            </e-columns> 
 
            <e-summary-rows> 
                <e-summary-row show-caption-summary="true" show-total-summary="false"> 
                    <e-summary-columns> 
                        <e-summary-column summary-type="Sum" format="{0:N2}" display-column="Freight" datamember="Freight" /> 
                    </e-summary-columns> 
                </e-summary-row> 
            </e-summary-rows> 
 
        </ej-grid> 
 
Refer to the documentation Link:- 

Screenshot:- 
 
 
Please get back to us if you need any further assistance. 
 
Regards,
Farveen sulthana T
 


Marked as answer

NE Neider July 14, 2020 04:09 PM UTC

It works, thank you.


FS Farveen Sulthana Thameeztheen Basha Syncfusion Team July 15, 2020 04:56 AM UTC

 Hi Neider,  

Thanks for your update. Please get back to us if you need any further assistance. We are happy to assist you. 

Regards, 
Farveen sulthana T 


Loader.
Up arrow icon