Hi Manolo,
We regret you to inform that, for relational data source, it is not possible to change row/column headers to required format in PivotGrid internally. But, it can be achieved in sample level by following ways.
1. You can directly bind the raw data-set (JOSN data) in desire format for date field to display in PivotGrid. (or)
2. You can use the “load” event to convert the desired date format of the datasource data (raw data) and bind it to PivotGrid to change the formatting in desired headers. Please find the below code example to achieve this.
Sample Code:
|
function onLoad(args) {
for (var i = 0; i < pivot_dataset.length; i++) {
var val = (pivot_dataset[i])["Date"]; // Select field to set desired date format
val = new Date(val);
//ej.widgetBase.formatting("{0:" + DateTime format string + "}", value, localization);
pivot_dataset[i].Date = ej.widgetBase.formatting("{0:" + "MM'/'dd'/'yyyy" + "}", val, "es-ES"); // To convert the date format as per the applied format string and localization
}
args.model.dataSource.data = pivot_dataset;
}
|
Thanks and Regards,
Ramesh G
