Sorting in PivotGrid

5 posts, 0 answers
  1. Mohan
    Mohan avatar
    9 posts
    Member since:
    Aug 2018

    Posted 02 Apr 2019 Link to this post

    Hello Team,

     

    Am expecting PivotGrid to display value into following order 1, 2, 12 and then 1011 but PivotGrid is displaying them into 1, 1011, 12 and then 2.

    How can this be fixed?

     

    Thanks,

    Mohan

     

  2.
  3. Attila Antal
    Admin
    Attila Antal avatar
    609 posts

    Posted 05 Apr 2019 Link to this post

    Hi Mohan,

    What I can think of is that the DataType for that field coming from the DataSource may not be numeric (integer, decimal, etc...) and that is why it is being treated as string. In addition to that, you may try defining the  DataFormString property for row field and make it number. Have you tried that one?

    Kind regards,
    Attila Antal
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  5. Mohan
    Mohan avatar
    9 posts
    Member since:
    Aug 2018

    Posted 02 May 2019 in reply to Attila Antal Link to this post

    Yes, data type for column was string  which was causing issue.
  7. Mohan
    Mohan avatar
    9 posts
    Member since:
    Aug 2018

    Posted 15 May 2019 in reply to Attila Antal Link to this post

    Yes it helps. thanks.
  8.
  9. Attila Antal
    Admin
    Attila Antal avatar
    609 posts

    Posted 15 May 2019 Link to this post

    Hi Mohan,

    Thank you for sharing your feedback, I am glad to hear the suggestion was helpful!

    Kind regards,
    Attila Antal
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top