Alphanumeric Sorting in AR6

Alphanumeric Sorting in AR6

Posted by: krishnamoorthy.srinivasan on 11 August 2023, 8:09 am EST

• 

  krishnamoorthy.srinivasan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 August 2023, 8:09 am EST

  Is there any option to do Alphanumeric sorting in AR6 Farpoint Spread.
  
  We have tried Clip property, but it considers as string only.
  
  Data is like: 1,11,2,3,10,Deposit
  
  Actual Output:
  
  1,10,11,2,3

  Expected Output:
  
  1,2,3,10,11,Deposit

  Could please do the needful?

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 14 August 2023, 8:16 am EST

  Hi Balasuganya,

  Please Note: ActiveReports 6 is a legacy version of ActiveReports and we no longer provide support for the same. It is suggested you upgrade to the latest version of ActiveReports i.e. ActiveReports 17 for many new features, bug fixes, and prompt support.
  
  You may download the latest version of ActiveReports from here Download ActiveReports and try it free for the first 30 days!

  Although there are no direct methods to do Alphanumeric sorting in ActiveReports. However, you can implement a custom sort to do the alphanumeric sorting and return the sorted values.

  Please find attached a sample implementing the same in ActiveReports 17.

  Regards,
  
  Anand

  SectionReport_Sort.zip
  
  PageReport_Sort.zip