RadPivotGrid Filter Values on Code

2 posts, 0 answers
  1. Jose
    Jose avatar
    6 posts
    Member since:
    Nov 2013

    Posted 31 Mar 2014 Link to this post


    I am using IE 11 and the controls' version is 2013.2.717.35. My project is on C# and I use Visual Studio 2010.

    I have a Pivot Grid control with PivotGridReportFilterField fields. How do I access on the server code, for example on the item command event, the filter values the user might have selected for each PivotGridReportFilterField fields? I need this information for a particular case on my application to filter another query.

    Please provide me a sample code.

    Note: I found this link - http://www.telerik.com/help/aspnet-ajax/grid-gridtableview-get-filterexpressions.html

    It seems to be what I need for the case of a grid but I could not apply the suggestions to my pivot grid.

    Thanks in advance,

  2. Vasil
    Vasil avatar
    1623 posts

    Posted 03 Apr 2014 Link to this post

    Hi Jose,

    The RadPivotGrid does not provide way for accessing the filter expressions as in the RadGrid, because if it's more complex way of internal filtering. The closest thing is to use IQueryable as DataSource and use it's Expression.
    Another option is to use the FilterWindow property of the PivotGrid to get the filtering window, and then the SetBox property of this window to access the RadListBox that holds filter values that can be checked.


    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top