Sorting Kit Numerically in Report Dsigner

  • 23 August 2022
  • 2 replies

Userlevel 4

 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,



Best answer by Calvin 25 August 2022, 19:52

View original

2 replies

Userlevel 4

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,


Userlevel 7

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


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