Expand and Collapsing of rows

3 posts, 0 answers
  1. hamish
    hamish avatar
    44 posts
    Member since:
    Jun 2007

    Posted 23 Feb 2015 Link to this post

    We have a pivot grid that has 3 levels of dimensions to it: (for example):
    1 Company
         1.1. Account
                1.1.1. Ticker
    2 Company
         2.1. Account
            2.1.1. Ticker
    When the user clicks on the plus sign next to Company it expands out to accounts and then if they click on the plus sign next to Account it expands to Ticker etc. The problem we are having is as soon as we refresh the data the previously selected expansions all go away and it defaults to back what it was at the start either expanded or collapsed. We are refreshing the data by rebuilding a collection of data records which we then assign to the Pivots dataprovder.Items source .
    My question is how can we maintain the previously expanded and collapsed rows between data refresh's - thank you
  2. hamish
    hamish avatar
    44 posts
    Member since:
    Jun 2007

    Posted 25 Feb 2015 in reply to hamish Link to this post

    Would it be possible to get a response to this question. This is causing us some difficultly. Also as the data providers data source we are using an observable collection. I would have thought that changes made to the observable collections fire the notifyproperty changed event which the pivot grid should react to. It does not appear to do so and we have to re assign the collection to the item source which in turn refresh's the grid but resets all of the rows collapsed status.
    Look forward to your response
  3. DevCraft R3 2016 release webinar banner
  4. Polya
    Polya avatar
    190 posts

    Posted 26 Feb 2015 Link to this post

    Hi Hamish,

    RadPivotGrid doesn't support such scenario out of the box. However there is a workaround that you can use - you can create a dictionary and save the state of the rows/columns. After the provider is completed (you can use StatusChanged event of the provider) you can try to find each group from the dictionary and restore its state. I've prepared a sample project to demonstrate this approach.

    Hopefully this helps and is suitable for your scenario.


    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