GroupRow order

[Stefania]

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>

[Rosen Vladimirov]

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

[Stefania]

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

[Rosen Vladimirov]

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

[Stefania]

Thanks, I don't see the attachment

[Rosen Vladimirov]

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