How to set the header text in the PivotGrid?
This KB illustrates that how to set header text in PivotGrid.
Solution:
You can use the following code examples to change the header text in the PivotGrid with respective to JS, ASP and MVC platforms.
JavaScript
$(function () {
$("#PivotGrid").ejPivotGrid({
url: "../wcf/OLAPService.svc", afterServiceInvoke: "OnChangeHeaderText"
});
});
function OnChangeHeaderText(args) {
var JsonData = this.getJSONRecords();
JsonData[0].Value = "Header Text";
this.setJSONRecords(JSON.stringify(JsonData));
}
ASP
<ej:PivotGrid ID="OlapChart1" runat="server" Url="../wcf/PivotGridtService.svc">
<ClientSideEvents AfterServiceInvoke="OnChangeHeaderText"/>
</ej:PivotGrid>
<script type="text/javascript">
function OnChangeHeaderText(args) {
var JsonData = this.getJSONRecords();
JsonData[0].Value = "Header Text";
this.setJSONRecords(JSON.stringify(JsonData));
}
<script/>
MVC
@Html.EJ().Olap().PivotGrid("PivotGrid1").Url(Url.Content("~/wcf/PivotGridService.svc")).ClientSideEvents(clientSideEvent => clientSideEvent.AfterServiceInvoke("OnChangeHeaderText"))
<script type="text/javascript">
function OnChangeHeaderText(args) {
var JsonData = this.getJSONRecords();
JsonData[0].Value = "Header Text";
this.setJSONRecords(JSON.stringify(JsonData));
}
<script/>
