HAVING PROBLEMS WITH SORTING DATA

[longfellow]

I have the following output from my table in the database
sorted using ORDER BY CLAUSE , sort is on STUDNO field.

STUDNO AGE HEIGHT WEIGHT RACE
- -- ----- ---------- ---------- ----------
1 32 170 60 Asian
2 31 171 60 African
3 30 172 70 Asian
10 29 173 50 Asian
11 28 174 50 Asian
12 27 175 60 Asian
But when i try to capture the same in Crystal Reports
I get the following output

STUDNO AGE HEIGHT WEIGHT RACE
- -- ----- ---------- ---------- ----------
1 32 170 60 Asian
10 29 173 50 Asian
11 28 174 50 Asian
12 27 175 60 Asian
2 31 171 60 African
3 30 172 70 Asian
I dont have any summary fields or group fields.
When i tried using the sort order button
from the standard tool bar it did not give me the desired
result. Even if any data is added in the database
i am not able to set the sortorder like in
the following
1
2
3
4
5
6
7
8
9
10
11
Instead if i have 4 values and am adding another 5 values
it appears something like the following in CR
2
10
11
12
3
4
5
why is this happening in CRYSTAL REPORTS
How so i solve the problem
Its urgent can someone throw some light

Thanking You in Advance

LongFellow

 

[synapsevampire]

Studno is coming across as a text type (varchar or some such).

Either create a formula and convert it to a number: num({yourfield})

or fix the datatype being passed.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[longfellow]

I tried the above formula still my output remains the same.
Can Mr.KenHamady throw some light on this please

Thanking you

Long fellow

 

[longfellow]

Hey sorry

Last night i used a wrong formula. But instead i went to my Database and converted the field to a number field and the problem got solved .Thank you very much for the fantastic Input


Once again thank you

Longfellow