I have a crystal report that I am sorting the Field_ID in ascending order, but it sorts it not like 1 thru 50. It ends up looking like this.
It should look like this.
I know crystal Reports must have a way of doing this correctly. If not, I will have to make a new column in the database's table and name it ID#. The add alphabets to sort.
USING CRYSTAL REPORTS 2008 and Oracle 10 G