1. Home
  2. Forum
  3. ASP.NET Web Forms
  4. how to change the group Summary Currency type to something other than dollars

how to change the group Summary Currency type to something other than dollars

Hi 
I Need to do a grouped summary of data in a grid but it has to be in Danish currency. 
I have looked around and i cannot seem to find anything on how to set the currency type.
I tried setting the locale of the grid to da-DK but it does not work!!

please help!!  

1 Reply
SR Sellappandi Ramu Syncfusion Team March 23, 2015 02:24 PM UTC

Hi Lizette,

Thanks for using Syncfusion products.

We have analyzed your requirement for “Grouped summary of data by using da-DK currency” and created a sample. The sample can be downloaded from following link:

Sample link: http://www.syncfusion.com/downloads/support/forum/118579/Sample_118579603018419.zip

Please refer the following steps and code snippet for enable localization.

1. Need to refer the corresponding localization script file like below.

<head runat="server">

<meta charset="utf-8" />

<meta name="viewport" content="width=device-width, initial-scale=1.0" />

<title><%: Page.Title %></title>

<link rel='nofollow' href="~/favicon.ico" rel="shortcut icon" type="image/x-icon" />

<link rel='nofollow' href="Content/ej/ej.widgets.core.min.css" rel="stylesheet" />

<link rel='nofollow' href="Content/ej/default-theme/ej.theme.min.css" rel="stylesheet" />

<script src="Scripts/jquery-1.10.2.min.js"></script>

<script src="Scripts/jsviews.min.js"></script>

<script src="Scripts/jsrender.min.js"></script>

<script src="Scripts/jquery.easing-1.3.min.js"></script>

<script src="Scripts/jquery.globalize.min.js"></script>

<script src="Scripts/minified/globalize.culture.da-DK.min.js"></script>

<script src="Scripts/ej.web.all.min.js"></script>

<meta name="viewport" content="width=device-width" />

</head>

2. Need to add the locale properties in grid sample.

<ej:Grid ID="OrdersGrid" runat="server" AllowScrolling="true" AllowGrouping="true" AllowPaging="True" Locale ="da-DK" >

3. Need to set the format to currency column.

<ej:SummaryColumn SummaryType="Average" DisplayColumn="Freight" DataMember="Freight"

Prefix="Average = " Format="{0:C}" /></SummaryColumn>

For your reference we have attached online kb link for how to enable the localization in grid?

Please refers the online kb link:

http://www.syncfusion.com/kb/4008/how-to-enable-localization-in-grid

Please let us know if you have any queries.

Regards,Sellappandi R


Loader.
Up arrow icon