Hi everyone,
I am wondering what is the right way to sort Kit in Report Designer. I have build a report based on below:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/1e8de8a0-1027-483d-984b-d6a28b257e6a.png)
I have add below sort filter:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2d854473-9b6d-45f8-81fe-434e7c152f65.png)
When I run the report, the KitHeaderID is not sort numerical or Alphabetically and is all over the place:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/562da3d7-79ec-441f-9fd9-1194e5c7894b.png)
I went and look at Kit Specification and it would show the Kit in numerical order.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3aa55f6f-bad0-48e6-9bec-309892c895fb.png)
Does anyone have an idea what I need to do in order to have it sort numerically?
Kind regards,
Calvin
Best answer by Calvin
View original