We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Drill through

Thread ID:





144886 May 27,2019 06:14 PM UTC May 28,2019 12:53 PM UTC WinForms 1
Tags: PivotGridControl
Travis Chambers
Asked On May 27, 2019 06:14 PM UTC


The overview page on the syncfusion website mentions the ability to "drill through" and obtain the specific information on a data entry that contributes to the selected number. However, there appears to be no documentation on this for winforms.

How do you do the drill through in code (c#)?


Jagadeesan Pichaimuthu [Syncfusion]
Replied On May 28, 2019 12:53 PM UTC

Hi Travis,

Thank you for contacting Syncfusion support.

We have analyzed the reported query “How to achieve the drillthorugh support in the pivot grid control”. You can get the specific information for the selected cell by using the GetRawItemsFor method which is available in PivotEngine. GetRawItemsFor method is used to obtain the list of raw items for value cell, total cell or grand total cell in the pivot grid. You can find out the selected row and column index values by using CellClick event handler.

Please refer the following code sample.
        private Syncfusion.Windows.Forms.Grid.GridDataBoundGrid gridDataBoundGrid1; 
        public Form1() 
            this.pivotGridControl1.TableControl.CellClick += TableControl_CellClick; 
        //Get the raw items for selected cells(value and sumary cells) 
        private void TableControl_CellClick(object sender, Syncfusion.Windows.Forms.Grid.GridCellClickEventArgs e) 
            PivotGridControlBase pivotGridControlBase = sender as PivotGridControlBase; 
            if (pivotGridControlBase != null) 
                int row = pivotGridControlBase.CurrentCell.RowIndex - 1; 
                int col = pivotGridControlBase.CurrentCell.ColIndex - 1; 
                var rawItems = this.pivotGridControl1.PivotEngine.GetRawItemsFor(row, col); 
                this.gridDataBoundGrid1.DataSource = rawItems; 
Please let us know if you need any further assistance.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon