[Problem Description] The data in the order list is roughly as follows: line_no (character type) Buy_Qty Unit1 101 SHT 2 102 SHT .... 8 108 SHT 9 109 SHT 10 110 SHT 11 111 SHT 12 112 SHT ..... 20 120 SHT ....
Normal sorting should be the above, when establishing a view, if you use orde by line_no or no need to sort it, then 1 ................... .... 21 .... This does not meet our requirements; if you use the order by to_number (line_no), it will be correct; but can not use Order by in the view. This will think of the crystal report. Use to_number (line_no) to sort, test, do not understand, data is not the sort of what we want;
[Solution]: 1) Plus a field in the view (character type to transfer to digital type, only characters are all numbers): to_number (line_no) line_no2) Sort by line_no in the crystal report