Change value in captions group and summary group

Question

Hello, I want to know how can I modified the value showed in GroupCaption and in the Summary Column. This is the way I want to change it:

In the Grid above I want to put my own custom values in the last column shown in red, in the Caption Groups and in the Summary Group, each value is diferent. How can I do that?

This is my code that to create the grid:

locale="@(System.Globalization.CultureInfo.CurrentCulture.Name.ToString())">

() {"excelExport" })>

@{

var GroupedCols = new List() { "PClass", "ProductName" };

}

Mohammed Farook J · Answer

Hi Neider, Thanks for contacting Syncfusion support. You can customize the group caption template and summary group caption by the following way. Group caption template

. . . In the code example we can customized the group caption by using captionTemplate in groupSettings. Summary Group Caption

… Please find the documentation https://ej2.syncfusion.com/aspnetcore/documentation/grid/grouping/#caption-template Regards, J Mohammed Farook

Neider · Answer

Thank you. How can I do that using the js1 version of syncfusion and using jsRender in the template?

That doesn't solve my problem, I'll show my grid code again, because before didn't paste well:

Target:

Neider · Answer

@{ var GroupedCols = new List() { "PClass", "ProductName" }; }

() {"excelExport" })>

Neider · Answer

With the code that you share with me, I only could modify the tittle of the group.

Farveen Sulthana Thameeztheen Basha · Answer

Hi Neider, 

Query#:- How can I do that using the js1 version of syncfusion and using jsRender in the template? 

#Group Caption Format:- 

To achieve this requirement we suggest you to use CaptionFormat property of group-settings property. Refer to the documentation Link for more information :- 
https://help.syncfusion.com/aspnet-core/grid/grouping#group-caption-formatgroup-caption-template 
 
#Summary Group Caption:-  

To customize the Summary Group caption we suggest you to use template property of e-summary-columns.  Refer to the documentation Link for more information :- 
https://help.syncfusion.com/aspnet-core/grid/summary#summary-template 
 
If the above documentation link doesn’t meet your requirement, please get back to us with further details. 

Regards, 
Farveen sulthana T

Neider · Answer

Hello, thanks for answering, I already check those, but I have not been able to exclude certain groupings.

For example with the grid bellow I want to check if the grouping name is "Renta fija" and in this case change the value that I want to show, or check if the group is in the highest level or in the lowest level and based on it change the value.

Farveen Sulthana Thameeztheen Basha · Answer

Hi Neider, Query#:- check if the grouping name is "Renta fija" and in this case change the value that I want to show, or check if the group is in the highest level or in the lowest level and based on it change the value. From your query we understood you need to change corresponding Field Value based on Grouped Items. We can achieve the same using CaptionFormat of group-settings as we suggested in previous update. Based on number of records under the current Group we have customized the group caption value. Refer to the code example:-

. . .

Refer to the screenshot:- We have prepared sample with simple data. Refer to the sample Link:- https://www.syncfusion.com/downloads/support/forum/154145/ze/Sample824458861.zip Please refer the below table for the possible values that can be used in group caption template. {{:field}} Defines the field name of the current group column(in your case Perfil) {{:key}} Defines the current group value(in your case Profile A) {{:count}} Defines the number of records under the current group {{:headerText}} Defines the headerText value of the current group column(header text of the column with field Perfil) If we misunderstood your query, please share us the detailed Explanation of your requirement and Demonstrate based on our provided sample for better understanding. Regards, Farveen sulthana T

{{:field}}	Defines the field name of the current group column(in your case Perfil)
{{:key}}	Defines the current group value(in your case Profile A)
{{:count}}	Defines the number of records under the current group
{{:headerText}}	Defines the headerText value of the current group column(header text of the column with field Perfil)