PivotGridSortOrder.None ?

[Chau]

I need to disable the sort order for my PivotGridRowField, but can't find a way to remove the SortOrder.
In RadGrid, there is an enum for GridSortOrder.None.
Can we have this similar enum for RadPivotGrid or how do I disable the sort for PivotGridRowField.
Thanks for any suggestion,
Chau

[Andrey]

Hello,

There is an Enum that holds the SortOrder value. You could set the SortOrder for a given, but the Enum only supports Ascending and Descending. Currently we do not support natural order. This is true because we are sorting the data prior creating the Pivot structure and that is why the data is always sorted.

Greetings,
Andrey
the Telerik team

[Chau]

Thanks Andrey for your reply. Yes, I saw those two enums for radpivotgrid SortOrder before posting, and I wanted to request if Telerik could provide a new enum of None (just like for RadGrid). 

[Andrey]

Hi,

As I stated in my previous reply, this option could not be implemented because the Pivot engine does not support it. If you check the excel Pivot engine you will see similar behavior.

Greetings,
Andrey
the Telerik team

[Chau]

I am using the RadPivotGrid control just for its expand/collapse column features and I am binding the grid to a set of datarows which are built with a pre-defined order.  That's why I cannot set the sortorder of ascending/descending.  Do you know if RadGrid has the Expand/Collapse column feature? Thanks.

[Andrey]

Hi,

The answer depends on what do you mean by expand/collapse column. If you meant hierarchical structure the could be expanded and collapsed, yes, RadGrid has such functionality as demonstrated in this online demo application.

If you have in mind the collapsible header of the PivotGrid then I am afraid there is no such functionality in RadGrid.

If RadGrid satisfies your requirement you could use it and get the none sort order. If not, I am afraid that the PivotGrid could not display unsorted data.

Kind regards,
Andrey
the Telerik team

[Chau]

I only need to collapsible header feature of RadPivotGrid (with no other filter/sort), so perhaps an enhancement to RadGrid would be to provide that same functionality.
Thanks,
Chau

[Andrey]

Hello,

You could log this feature request in our feedback portal and the other users could vote for it and thus to increase its priority.

Based on the popularity our Dev team will decide whether and when to implement it.

Kind regards,
Andrey
the Telerik team

[Yohan]

Hello,

I'm using OLAP Cube connection to pivot grid and I need to disable sorting by default because I have already sorted the cube data in appropriate order. i have attached samples of current pivot grid sorting behavior which is not acceptable in my case. I want to avoid pivot grid sorting in simple terms. (Excel support the mentioned scenarios by showing the exact data in cube as it is)

Regards,
Yohan

[Antonio Stoilkov]

Hi Yohan,

Unfortunately, the desired functionality is not available in the RadPivotGrid control. Currently there is no way to leave the data in its original state (the way it is passed from the data source).

Regards,
Antonio Stoilkov
Telerik

[Duke]

Hello, All.
I found a work around.

Add sequence to your header text, like 01.XXXX,02.XXX,03.XXX .....
The pivot grid will display the header in number order. And use string.Substring() to truncate the the text only remain the part of XXXX.

e.g.
01.Microsoft will show as Microsoft but show as the first row in the grid.
02.Apple will show as Apple in second. 

Hope it's helpful.

[Yohan]

Hello all,

I wish if there is a proper way because i have a complex cube with date dimensions, time detentions and my cube. there will be a lot of re work and performance concern if i do this, any way this is a good idea.

Regards,
Yohan

[Peter]

Here's another vote for the PivotGridSortOrder.None. We are struggling in our project because of not having the option to let our cubes handle the sorting and had to do a lot of coding to work around this issue for certain attributes (week number in date hierarchies as an example).

Sincerely,
Peter

[Antonio Stoilkov]

Hi Peter,

I happy to announce that we have implemented PivotGridSortOrder.None and it is now available as option for sorting. You could set RadPivotGrid AllowNaturalSort property to true in order to enable the third state of sorting in the UI when clicking the sort icon. The feature is available in the latest official release of RadControls.

Regards,
Antonio Stoilkov
Telerik

 

 

[Rayko]

Hi Antonio,

Is there a option to set natural sorting as default?

Regards,
Rayko

[Angel Petrov]

Hello Rayko,

You can directly set the AllowNaturalSort property to true in the markup.

ASPX:

<telerik:RadPivotGrid  AllowSorting="true" AllowNaturalSort="true" runat="server">

Or in the code-behind

C#:

protected override void OnLoad(EventArgs e)
      {
          base.OnLoad(e);
          RadPivotGrid1.AllowSorting = true;
          RadPivotGrid1.AllowNaturalSort = true;
      }

Regards,
Angel Petrov
Telerik

 

 

[Rayko]

Hi Angel,

Yes, I can set the option to true. But that doesn't set sorting to natural sort by default. Initially it's set to ascending.

Regards,
Rayko

[Angel Petrov]

Hi Rayko,

You can try setting the SortOrder property of the desired fields to None as demonstrated below.

ASPX:

<telerik:PivotGridRowField DataField="Color" SortOrder="None" ShowGroupsWhenNoData="true" UniqueName="Color">
</telerik:PivotGridRowField>
<telerik:PivotGridColumnField DataField="Class" SortOrder="None" UniqueName="Class">
</telerik:PivotGridColumnField>

If you want some specific type of sort order you can use the RadPivotGrid.Sort method.

Regards,
Angel Petrov
Telerik

 

 

[Rayko]

Hi Angel,

Is there no general option to disable the sort order? So I have to hook the FieldCreated event to set it for each field which I drag from the All Fields list.

 

Regards,

Rayko

[Angel Petrov]

Hi Rayko,

Indeed there is no property that can help you achieve the desired goal. Considering this I recommend logging a feature request in our feedback portal. That way our developers will examine the matter and if possible improve the control functionality for a future release.

Regards,
Angel Petrov
Telerik