Solved

Sorting Kit Numerically in Report Dsigner

  • 23 August 2022
  • 2 replies
  • 31 views
C
Rank
Userlevel 4
Badge

 Hi everyone, 

I am wondering what is the right way to sort Kit in Report Designer. I have build a report based on below:

 

I have add below sort filter:

When I run the report, the KitHeaderID is not sort numerical or Alphabetically and is all over the place:

I went and look at Kit Specification and it would show the Kit in numerical order. 

Does anyone have an idea what I need to do in order to have it sort numerically?

Kind regards,

Calvin

icon

Best answer by Calvin 25 August 2022, 19:52

View original

2 replies

C
Rank
Userlevel 4
Badge

Hi All,

I was able to find my answer on below thread:

The issue I was experiencing is because of the Grouping and the field that was used. Even thought sorting is setup, but the sorting will actually go through the Group field first before the Sorting field. 

Hopefully this help someone in the community!

Kind regards,

Calvin

Chris Hackett
Rank
Userlevel 7
Badge

Hi @Calvin - Thank you for sharing the resolution with the community!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved