GroupRow order

6 posts, 1 answers
  1. Stefania
    Stefania avatar
    107 posts
    Member since:
    May 2013

    Posted 04 Oct 2013 Link to this post

    Hi
    I created a pivotgrid and this my localdatasourceprovider.
    How can I change the row order? For example by another field "Sequential"..
    Now it orders by "CategoryDescription"
    Thanks

     <pivot:LocalDataSourceProvider x:Key="LocalDataProvider" >
                <pivot:LocalDataSourceProvider.RowGroupDescriptions>                 <pivot:PropertyGroupDescription PropertyName="CategoryDescription" CustomName="CategoryDescription" />                             </pivot:LocalDataSourceProvider.RowGroupDescriptions>             <pivot:LocalDataSourceProvider.ColumnGroupDescriptions>                 <pivot:PropertyGroupDescription PropertyName="BreakdownStepContextCode"></pivot:PropertyGroupDescription>                             </pivot:LocalDataSourceProvider.ColumnGroupDescriptions>             <pivot:LocalDataSourceProvider.AggregateDescriptions>                 <pivot:PropertyAggregateDescription PropertyName="CompletedStepsCount" CustomName="P" />             </pivot:LocalDataSourceProvider.AggregateDescriptions>         </pivot:LocalDataSourceProvider>

  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 04 Oct 2013 Link to this post

    Hi Stefania,

    You can check this article which explains different ways to sort the data inside RadPivotGrid. Feel free to contact us if it doesn't cover your scenario (in such case could you describe it with more details).

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. UI for WPF is Visual Studio 2017 Ready
  4. Stefania
    Stefania avatar
    107 posts
    Member since:
    May 2013

    Posted 07 Oct 2013 Link to this post

    Hi,
    thanks for your reply, but I was wondering if it exist something like this

      <pivot:LocalDataSourceProvider x:Key="LocalDataProviderPeriodType" x:Name="LocalDataProviderPeriodType">
                <pivot:LocalDataSourceProvider.RowGroupDescriptions>
                    <pivot:PropertyGroupDescription PropertyName="CategoryDescription"  ORDERBY="CategorySeq"/>
                </pivot:LocalDataSourceProvider.RowGroupDescriptions>
     
    etc ..

    where CategorySeq is another field in my DB

    Or, as I suspect, I can only decide the order (ASC or DESC) of my PropertyName Field.

    Thanks
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 07 Oct 2013 Link to this post

    Hello Stefania,

    Unfortunately this is not possible in the moment. The only available sorting is described in the previously mentioned article. One option to achieve the desired effect is to create a custom class that implements IComparable interface and use it instead of the CategoryDescription. We've prepared a sample project which you can use as a reference.

    Hopefully this helps.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  6. Stefania
    Stefania avatar
    107 posts
    Member since:
    May 2013

    Posted 07 Oct 2013 Link to this post

    Thanks, I don't see the attachment
  7. Answer
    Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 07 Oct 2013 Link to this post

    Hello Stefania,

    Please accept my apology for this mistake. You can find the project attached now. Feel free to contact us in case you have any problems or concerns.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top
UI for WPF is Visual Studio 2017 Ready