How to sort record

[296097]

A400 01 AMERICAN PLUMBING CO OF WINONA INC 450 44TH AVE
DIST 6 01 DISTRICT ENGINEER 2900 48TH ST N W
E0038 01 EATON CONSTRUCTION RR 1 BOX 60
1338 01 GARY LOVELACE - R.E. 2900 - 48TH STREET N.W.
H438 01 HOFFMAN CONSTRUCTION COMPANY 123 COUNTY HWY A
IN DIS 01 INTER PROG MAIL STOP 440 MAIL STOP 440
M630 01 MINNOWA CONSTRUCTION INC 850 WICKETT DR N W


I would like for my record A letter followed by a number to appear first and if the field contains more than one letter then it will be sorted right after i finish sorting the one with only one letter and follwed by a number.My field type is a string and i am trying to do this using crystal report 8.5. please help i am fairly new to cr and i do not know where to put the formula for this.i would like for my record to appear like the bottom one. if someone can save my life i am greatly appreciate the help. thank you

A400 01 AMERICAN PLUMBING CO OF WINONA INC 450 44TH AVE
E0038 01 EATON CONSTRUCTION RR 1 BOX 60
H438 01 HOFFMAN CONSTRUCTION COMPANY 123 COUNTY HWY A
M630 01 MINNOWA CONSTRUCTION INC 850 WICKETT DR N W
DIST 6 01 DISTRICT ENGINEER 2900 48TH ST N W
IN DIS 01 INTER PROG MAIL STOP 440 MAIL STOP 440
1338 01 GARY LOVELACE - R.E. 2900 - 48TH STREET N.W.

 

[lbass]

I responded to your other post, but forgot to mention that you should then go to report->sort fields and use the formula I suggested as your sort formula. You can use your original ID field for display in your report.

-LB

 

[296097]

i do not see any any link from report to sort field.probably you are using different version of CR. i am using CR 8.5

 

[lbass]

If you look in the toolbar at the top, you will see "Report". In the dropdown for "Report" is "Sort Records". Click on this and then move the formula from the list on the left to the right.

-LB