Drill Through Not Work and information about it

I use Drill Trough of PivotGrid with Relational Mode and WebApi Controller for initialize grid. I can not find Server Event when click on cell and I active Drill Through. I use your documentation but I can't find it. Where data are calculate for drill through? Another problem is that I have header column of PivotGrid with formatted text changed(from me server-side) and drill through not work..explanation for this two problems? Thank you.

2 Replies

SA Scintilla Arul Jothi Raj Syncfusion Team March 15, 2018 04:07 PM UTC

Hi Simone, 

Please find the response below. 

Query 
Response 
I use Drill Trough of PivotGrid with Relational Mode and WebApi Controller for initialize grid. I cannot find Server Event when click on cell and I active Drill Through. I use your documentation but I can't find it. Where data are calculate for drill through? 
Currently, we don’t have server-side cell click event support. Meanwhile we have provided a work around solution in the “DrillThrough” event. Please find the sample and code snippet below for your reference. 
Code Snippet: [C#] 
[System.Web.Http.ActionName("DrillThrougCellClick")] 
[System.Web.Http.HttpPost] 
public Dictionary<string, object> DrillThrougCellClick(Dictionary<string, object> jsonResult) 
{ 
  Dictionary<string, object> dict1 = new    Dictionary<string, object>(); 
 return dict1; 
 } 
 
Code Snippet: [JS] 
drillThrough = function (evt) { 
var drilledDta = { dataSource: this._dataSet, selectedData: evt.selectedData }; 
$.ajax({ 
"type": "POST", 
"url": "../api/RelationalGrid/DrillThrougCellClick", 
"contentType": "application/json; charset=utf-8", "dataType": "json","async": false, 
 "data": JSON.stringify(drilledDta) 
 ,success: function (msg) {}, error: function (msg) {}        }); 
} 
 
Sample Link: http://www.syncfusion.com/downloads/support/forum/136434/ze/CellClickDemo109972829 
 
Another problem is that I have header column of PivotGrid with formatted text changed(from me server-side) and drill through not work..explanation for this two problems? 
We confirmed that DrillThrough for formatted text doesn’t work properly is an issue and logged a defect report. The fix for the issue is available in our upcoming Essential Studio 2018 Volume 1 release which is estimated to be rolled out on end of March 2018. 

Please let us know if you have any concern. 
Regards, 
Scintilla A 



SA Scintilla Arul Jothi Raj Syncfusion Team April 25, 2018 05:11 PM UTC

Hi Simone, 
We are glad to announce that our Essential Studio Volume 1, SP 2 2018 (v16.1.0.37) is rolled out and is available for download under the following link. 
The fix for the issue “DrillThrough for formatted text doesn’t work properly is included in this version. Meanwhile, we have prepared a sample for your convenience. Please find the sample in the below link. 
And, we thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 
Regards, 
Scintilla A 


Loader.
Up arrow icon