C1FlexPivotPage - Sort a column - show your own detail window

C1FlexPivotPage - Sort a column - show your own detail window

Posted by: peter.grefberg on 7 November 2017, 2:41 am EST

• 

  peter.grefberg

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 November 2017, 2:41 am EST

  I have a problem with sorting when creating a custom showdetail window for flexpivot.

  When I’m not sorting the flexpivotgrid it works great, I get the right details for my custom detailwindow, but when I’m sorting the flexpivotgrid first, then I get the wrong results from getdetail function.
  
  I guess it´s because I have sorted the flexpivotgrid and not the FlexPivotTable in flexpivotengine

  It works with your standard “show detail” in contextmenu, but I want to have a custom window.
  
  Is there a way to sort the flexpivottable when sorting the flexpivotgrid or to get the “right” sorted rownumber from flexpivottable.

  My code for getting details

  C1FlexPivotPage.FlexPivotEngine.GetDetail(C1FlexPivotPage.FlexPivotEngine.FlexPivotTable.Rows(hti.Row - iOlapEngineCols), C1FlexPivotPage.FlexPivotEngine.FlexPivotTable.Columns(hti.Column - iOlapEngineRows).ColumnName)

  So, if I have row 3 with item 321, click on show details it works great. If I then sort the result on values, stil on the same row, show details, it still shows the detail rows based on the original unsorted values, not the new row 3 with intem 123.

  Then, the next question. I have a resultset containing field Custno, Value, Item no, and Aggregated values.
  
  in the selectable columns, it is now sorted from A-Z. I vould like to have the columns in exacly the same order as in my resultset.
  
  How to do this? I would be more logical to have the columns in the as is order then sort it?

  Cheers

  Peter

• 

  meenakshi.singh

  

  • Post Options:
  • Link
    Copy

  Posted 9 November 2017, 4:32 am EST

  Hi Peter!

  We are working on this, and will get back to you once it is resolved.

  Regards,
  
  Meenakshi

• 

  peter.grefberg

  • Post Options:
  • Link
    Copy

  Posted 9 November 2017, 9:44 am EST

  Thanks!

• 

  alexeys

  • Post Options:
  • Link
    Copy

  Posted 23 April 2018, 2:34 am EST

  Hi Peter, thank you for your patience.

  1. Use C1FlexPivotPage.FlexPivotGrid.GetDetail to get details instead of C1FlexPivotPage.FlexPivotEngine.GetDetail

  Example:

              
  
  	this.c1FlexPivotPage1.FlexPivotGrid.RowColChange += FlexPivotGrid_RowColChange;
  
          ...
  
          private void FlexPivotGrid_RowColChange(object sender, EventArgs e)
          {
              c1FlexGridDetails.DataSource = c1FlexPivotPage1.FlexPivotGrid.GetDetail(c1FlexPivotPage1.FlexPivotGrid.Selection.TopRow, c1FlexPivotPage1.FlexPivotGrid.Selection.LeftCol);
          }
  

  2. These is no way to get the columns unsorted. We can consider this feature for future release if you’re interested in.

  Thanks,

  • Alexey