We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

DataGrid issue(aggregate column no format)

Thread ID:

Created:

Updated:

Platform:

Replies:

146340 Jul 31,2019 09:31 PM UTC Aug 6,2019 01:49 PM UTC ASP.NET Core - EJ 2 5
loading
Tags: DataGrid
Raul Montan Rodriguez
Asked On July 31, 2019 09:31 PM UTC

hello, I am having a problem when formatting my aggregate column C2, I apply the format C2 in the format property and it simply does not do it, in the console it does not give any type of error simply it is not formatted to C2 nor any another type

Thavasianand Sankaranarayanan [Syncfusion]
Replied On August 1, 2019 10:10 AM UTC

Hi Raul, 

Greetings from Syncfusion support. 

We have prepared a sample based on your details but we are unsuccessful to reproduce the issue from our end. 

Refer the below code example. 

[index.cshtml] 

<ejs-grid id="Grid" dataSource="ViewBag.datasource" allowPaging="true"> 
        <e-grid-aggregates> 
            <e-grid-aggregate> 
                <e-aggregate-columns> 
                    <e-aggregate-column field="Freight" type="Sum" format="C2" footerTemplate="Sum:${Sum}"></e-aggregate-column> 
                </e-aggregate-columns> 
            </e-grid-aggregate> 
            <e-grid-aggregate> 
                <e-aggregate-columns> 
                    <e-aggregate-column field="Freight" type="Average" format="C2" footerTemplate="Average:${Average}"></e-aggregate-column> 
                </e-aggregate-columns> 
            </e-grid-aggregate> 
        </e-grid-aggregates> 
        <e-grid-groupsettings></e-grid-groupsettings> 
        <e-grid-pagesettings pageCount="5"></e-grid-pagesettings> 
        <e-grid-columns> 
            <e-grid-column field="CustomerID" headerText="Customer Name" width="150"></e-grid-column> 
            <e-grid-column field="Freight" headerText="Freight" TextAlign="Right" format="C2" width="160"></e-grid-column> 
            <e-grid-column field="OrderDate" headerText="Order Date" format="yMd" width="130"></e-grid-column> 
            <e-grid-column field="ShipCity" headerText="Ship Country" width="140"></e-grid-column> 
        </e-grid-columns> 
    </ejs-grid> 



Refer the screen shot. 

 

We have prepared a simple sample and it can be downloadable from the below location. 


If you still face the same issue then provide the following details. 

  1. Share the screen shot or video demonstration of the issue.
  2. Share the complete Grid code example.
  3. If possible try to reproduce the issue in the attached sample.
  4. Share the essential studio version details.

Regards, 
Thavasianand S. 


Raul Montan Rodriguez
Replied On August 1, 2019 03:42 PM UTC

thanks for your answer, the example you have works, but the same thing doesn't happen to me here I show you the images with what happened



Thanks Raul

Thavasianand Sankaranarayanan [Syncfusion]
Replied On August 2, 2019 06:28 AM UTC

Hi Raul, 

We can’t able to see  your attachments in this forum. So, can you please re-attach your screen shots. 

Refer the screen shot. 

 

Regards, 
Thavasianand S. 


Raul Montan Rodriguez
Replied On August 5, 2019 07:10 PM UTC

Hi Thavasianand, Thank you for your attention, here I send the images in a zip file, it is quite strange that I could not visualize the images in the post yet I can visualize it, but so that I can visualize it without problem I compressed it in the zip

Attachment: formatC2_fd37d03a.zip

Thavasianand Sankaranarayanan [Syncfusion]
Replied On August 6, 2019 01:49 PM UTC

Hi Raul, 

We have validated your given screens shots. We suspect that “Facturado” column values may be string in the Grid dataSource. So, please ensure on your end for that column value. Else please provide your sample dataSource to reproduce the issue from our end. If possible please try to reproduce the issue in the previously attached sample. 

Regards, 
Thavasianand S. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon