I have a report that sends an email and orders driver delivery drops by number. Each delivery is assigned a number from 1 onwards.
The order comes out fine until it gets to number “10” which it places after “1” rather than “9”. I have changed the order numbers to 10, 20 , 30 etc and still the same result. 100 comes after 10.7
<<Start:Orderby(Running Sheet 24[Outlet No],[Running Sheet Report Calc],FALSE)>>
Any ideas why? Pic attached