Skip to main content

 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

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

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

Reply


Terms & ConditionsCookie settings