Solved: Order of items email report - Page 2

Phil_Waite · 07-08-2020 04:52 AM

Hi,

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

Expression is

<<Start:Orderby(Running Sheet 24[Outlet No],[Running Sheet Report Calc],FALSE)>>

Any ideas why? Pic attached

thanks

Phil

Steve

Wrap the SELECT() expression in ANY(), then make sure the column type is Number.

View solution in original post