PivotGridControl Filters changed event

[Matthijs Huisman]

Hi,

I have a PivotGridControl with a PivotTableFieldList. If the user changes the setup of the Grid and adds a field to the Report Filter, I can catch the change of PivotFilters but NOT the changes in the content of the PivotFilter.

Let's say I have multiple years in a field and the user deselects on of the years (for instance 2014, 2015 but NOT 2016) -> how can I catch that event?

Thanks!

Cheers,

Matthijs

[Mohanraj Gunasekaran]

Hi Matthijs, 

 

Thanks for using Syncfusion products. 

 

In order to get the filtered value, you can use the Expression property in Filters.CollectionChanged event. Please refer the below code example and refer the below attached sample, 

 

Code example 

AddHandler Me.pivotGridControl1.Filters.CollectionChanged, AddressOf Filters_CollectionChanged 

Private Sub Filters_CollectionChanged(ByVal sender As Object, ByVal e As System.Collections.Specialized.NotifyCollectionChangedEventArgs) 

    If e.NewItems IsNot Nothing AndAlso TypeOf e.NewItems(0) Is FilterExpression Then 

        Dim expression As FilterExpression = TryCast(e.NewItems(0), FilterExpression) 

        Dim filteredvalue() As String = expression.Expression.Split(New String() { "||" }, StringSplitOptions.None) 

        Dim values As String =Nothing 

        For Each value As String In filteredvalue 

             values &= value.Replace(expression.DimensionName, String.Empty).Replace("=", String.Empty)+ Constants.vbCrLf 

        Next value 

    End If 

End Sub 

 

Sample link: PivotGridControl 

 

Please let us know if you have any further assistance. 

 

Regards, 

Mohanraj G. 

[Matthijs Huisman]

Hi,

Thank you for your answer, but you helped me already with your other post (id 128966)! The PivotSchemaDesigner.SchemaChanged event was the key -> this event fires when a filter expression is changed as well!

NB: the event you describe here only fires when an expression is added or removed from the filtercollection but (as far as I can tell from what I tried) it does NOT fire when the content of an expression is changed. But again the SchemaChanged event helped me out!

Thank you!

[Mohanraj Gunasekaran]

Hi Matthijs,  

 

Thanks for your update. 

 

We are glad to know that your reported problem has resolved. 

 

Please let us know, if you have any further assistance. 

 

Regards, 

Mohanraj G.