Category / Section
How to change "Total" string to other language?
1 min read
This KB illustrates that how to change "Total" string to other language.
Solution:
You can change the Total string to any desired language with respective to JS, ASP and MVC platforms by using the following code example.
JS
$(function () {
$("#PivotGrid1").ejPivotGrid({
url: "../wcf/OLAPService.svc", afterServiceInvoke: "OnChangeHeaderText"
});
});
function OnChangeTotalString(args) {
var JsonData = this.getJSONRecords();
for(i = 0; i < JsonData.length; i++)
{
if (JsonData[i].Value == "Total")
JsonData[i].Value = "Enter valid string (in different language)";
}
this.setJSONRecords(JSON.stringify(JsonData));
}
MVC
@Html.EJ().Pivot().PivotGrid("PivotGrid1").Url(Url.Content("~/wcf/OLAPService.svc")).ClientSideEvents(clientSideEvent => clientSideEvent.AfterServiceInvoke("OnChangeTotalString"))
<script>
function OnChangeTotalString(args) {
var JsonData = this.getJSONRecords();
for(i = 0; i < JsonData.length; i++)
{
if (JsonData[i].Value == "Total")
JsonData[i].Value = "Enter valid string (in different language)";
}
this.setJSONRecords(JSON.stringify(JsonData));
}
</script>
ASP
<ej:PivotGrid ID="PivotGrid1" runat="server" Url="../wcf/PivotGridtService.svc">
<ClientSideEvents AfterServiceInvoke="OnChangeTotalString"/>
</ej:PivotGrid>
<script>
function OnChangeTotalString(args) {
var JsonData = this.getJSONRecords();
for(i = 0; i < JsonData.length; i++)
{
if (JsonData[i].Value == "Total")
JsonData[i].Value = "Enter valid string (in different language)";
}
this.setJSONRecords(JSON.stringify(JsonData));
}
</script>
