C1FlexPivotPage - how to keep the fields unsorted in the select list

C1FlexPivotPage - how to keep the fields unsorted in the select list

Posted by: peter.grefberg on 12 December 2017, 11:26 pm EST

• 

  peter.grefberg

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 December 2017, 11:26 pm EST

  We have create a report, where the information is grouped logically.
  
  Then, when we shows this in in C1FlexPivotPage the list of available fields is * “sorted”
  
  .

  How to turn off the sorted stuffs. We must have the fields in the order of the resultset from the database? Now the user has to scroll up and down all the time instead of picking in our created order.

  Please, any suggestions?

  //Peter

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 14 December 2017, 7:19 am EST

  Hi Peter,

  You may use c1FlexPivotPage1.FlexPivotGrid.GridChanged event on load and reset all the columns Sort state by using column’s Sort property as follows:

  private void FlexPivotGrid_GridChanged(object sender, C1.Win.C1FlexGrid.GridChangedEventArgs e)
  {
        foreach(C1.Win.C1FlexGrid.Column c in c1FlexPivotPage1.FlexPivotGrid.Cols)
        {
             c.Sort = C1.Win.C1FlexGrid.SortFlags.None;
        }
   }
  

  Let me know if does not work for you. In that case, we request you to please share a stripped version of your application showing how you are grouping the information.

  Thanks,
  
  Ruchir Agarwal