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