Skip to main content
Solved

Sorting Kit Numerically in Report Dsigner


Forum|alt.badge.img

 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

Best answer by Calvin

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

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img
  • Jr Varsity III
  • August 25, 2022

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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • August 25, 2022

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings