Report not dispaying data in order

[awade]

Good Morning Everyone,

I have a report that generates the position of certain items. When I produce this report it doesn't put the data in order. All associated data with that position is correct, it is just not in numerical order. The attached screenshot shows the issue I am having. In the position column it should read 1,2,3,4 but in some cases the positions are not in order.

Is there anyway to fix this error.

Cheers

 

[boblarson]

Did you put a sort on that field in the report? You need to do so because sorts in Queries don't propagate through to reports.

 

[awade]

Thank you put the sort on that field and it worked.

"Sorting grouping button"
- Pos
--Ascending
---GroupHeader, NO
---GroupFooter, NO
---GroupOn, Interval
---GroupInterval, 1
---Keep Together, NO

Thank you very much for your help.