PivotGridSortOrder.None ?

20 posts, 0 answers
  1. Chau
    Chau avatar
    8 posts
    Member since:
    Feb 2010

    Posted 14 Mar 2013 Link to this post

    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
  2. Andrey
    Admin
    Andrey avatar
    836 posts

    Posted 19 Mar 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Chau
    Chau avatar
    8 posts
    Member since:
    Feb 2010

    Posted 19 Mar 2013 Link to this post

    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). 
  5. Andrey
    Admin
    Andrey avatar
    836 posts

    Posted 22 Mar 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  6. Chau
    Chau avatar
    8 posts
    Member since:
    Feb 2010

    Posted 22 Mar 2013 Link to this post

    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.
  7. Andrey
    Admin
    Andrey avatar
    836 posts

    Posted 27 Mar 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  8. Chau
    Chau avatar
    8 posts
    Member since:
    Feb 2010

    Posted 27 Mar 2013 Link to this post

    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
  9. Andrey
    Admin
    Andrey avatar
    836 posts

    Posted 29 Mar 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  10. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 12 Jan 2014 Link to this post

    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
  11. Antonio Stoilkov
    Admin
    Antonio Stoilkov avatar
    530 posts

    Posted 16 Jan 2014 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  12. Duke
    Duke avatar
    13 posts
    Member since:
    Jul 2013

    Posted 24 Jan 2014 Link to this post

    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.
  13. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 25 Jan 2014 Link to this post

    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
  14. Peter
    Peter avatar
    1 posts
    Member since:
    Jul 2014

    Posted 03 Jul 2014 Link to this post

    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
  15. Antonio Stoilkov
    Admin
    Antonio Stoilkov avatar
    530 posts

    Posted 04 Jul 2014 Link to this post

    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
     

    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.

     
  16. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 27 Mar 2015 in reply to Antonio Stoilkov Link to this post

    Hi Antonio,

    Is there a option to set natural sorting as default?

    Regards,
    Rayko
  17. Angel Petrov
    Admin
    Angel Petrov avatar
    1007 posts

    Posted 01 Apr 2015 Link to this post

    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
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  18. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 01 Apr 2015 in reply to Angel Petrov Link to this post

    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
  19. Angel Petrov
    Admin
    Angel Petrov avatar
    1007 posts

    Posted 06 Apr 2015 Link to this post

    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
     

    See What's Next in App Development. Register for TelerikNEXT.

     
  20. Rayko
    Rayko avatar
    27 posts
    Member since:
    Jul 2012

    Posted 07 Apr 2015 in reply to Angel Petrov Link to this post

    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

  21. Angel Petrov
    Admin
    Angel Petrov avatar
    1007 posts

    Posted 09 Apr 2015 Link to this post

    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
     

    See What's Next in App Development. Register for TelerikNEXT.

     
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017