Hi there, i notice a problem with vb and crystal report that is the sorting order. when i use the sql in my vb to do sorting. let said for example i want to order my vendor code and the following at the example of my vendor
1. OC
2. VEN-IDR
3. VEN-RM
4. VEND-USD

if i use vb to do order it is like the above order. but if i use crystal report to order it then i found that only 2 records will appear in my report. OC and VEND-USD appeared only.
do anyone have any idea on how to solve this kind of problem??

Thank you for your time.