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.
Unfortunately, activation email could not send to your email. Please try again.

FilterActionCompleted Event

Thread ID:





120515 Sep 22,2015 07:37 AM Sep 30,2015 05:59 AM Windows Forms 3
Tags: PivotGridControl
Sérgio Rodrigues Costa
Asked On September 22, 2015 07:37 AM

Hi, I´m trying to use "FilterActionCompleted" Event in a Windows Forms PivotGridControl to disable "ShowGrandTotals" on the last row, but the "FilterActionCompleted" event never gets to fire. 
Is there a better way to do it?
I have started trying to disable it in Load event. It worked, but when I made changes on filtering data, the GrandTotals returned.

Despite the fact I will use it in a VB.net app, here is the code in C#.

this.pivotGridControl1.FilterActionCompleted += new Syncfusion.Windows.Forms.PivotAnalysis.PivotGridControl.FilterActionCompletedEventArgs(this.pivotGridControl1_FilterActionCompleted);

private void pivotGridControl1_FilterActionCompleted(object sender, EventArgs e)
            pivotGridControl1.ShowGrandTotals = false;

Thanks in advance.

Adhikesevan Kothandaraman [Syncfusion]
Replied On September 23, 2015 06:46 AM

Hi Sergio,

Thanks for contacting Syncfusion Support.

The reported scenario can be achieved by using the QueryRowHeight event, set the row height for the GrandTotal row. Please refer to the following code example,

Code Example:

void TableModel_QueryRowHeight(object sender, Syncfusion.Windows.Forms.Grid.GridRowColSizeEventArgs e)


    if (this.pivotGridControl1.PivotEngine[e.Index - 1, this.pivotGridControl1.PivotRows.Count].CellType

             == (PivotCellType.GrandTotalCell | PivotCellType.ValueCell))


        e.Size = 0;

        e.Handled = true;




Sérgio Rodrigues Costa
Replied On September 29, 2015 10:52 AM

Well, I didn't found the event on with I have to trigger this function.
The "pivotGridControl1.TableModel.QueryRowHeight" event it is not exposed in VB.
I´m using VB.

Adhikesevan Kothandaraman [Syncfusion]
Replied On September 30, 2015 05:59 AM

Hi Sérgio,

Thanks for your update.

Please refer to the following code example to trigger the QueryRowHeight event in VB.net,

Code Example:

AddHandler Me.pivotGridControl1.TableModel.QueryRowHeight, AddressOf TableModel_QueryRowHeight

Private Sub TableModel_QueryRowHeight(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridRowColSizeEventArgs)

    If Me.pivotGridControl1.PivotEngine(e.Index - 1, Me.pivotGridControl1.PivotRows.Count).CellType = (PivotCellType.GrandTotalCell Or PivotCellType.ValueCell) Then

        e.Size = 0

        e.Handled = True

    End If
End Sub




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.

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.