Sort the detail section in CR

Hi,

Im developing a CR using CR 8.5,vb6 and access for my company project. I have do 2 mutiple column detail section in crystal report. 1 is for MFGNo list and another is for OEMNo list.Now the data is printed alternately like

101001 101002 101003 101004 -MFGNo
201001 201002 201003 201004 - OEMNo
102001 102002 102003 102004 -MFGNo
202001 202002 202003 202004 - OEMNo

I want the result as
101001 101002 101003 101004 -MFGNo
102001 102002 102003 102004 -MFGNo

201001 201002 201003 201004 - OEMNo
202001 202002 202003 202004 - OEMNo

I want to sort the data.How can i do so in CR...Please help me...Only this part is left in my report.....My boss getting tempered.......coz delay of the report. I will thank u forever for any kind help.

re: Sort the detail section in CR

sort the data in the sql query itself.

re: Sort the detail section in CR

How can i sort sql query? The problem is i put this 2 fields in detail section in CR(Detail A & Detail B), so it alternately repeat 1 by 1 a-b-a-b but
I want to display all a then all b?Please help me..