Link to home
Start Free TrialLog in
Avatar of Genius123
Genius123Flag for United States of America

asked on

Crystal Report sorting

Hello,

In the last column on the right, it's sorting the field EMARK like this:

BD10
BD5
BD8
BD9

I need to sort it like this:

BD5
BD8
BD9
BD10

Letters on the left could be 1, 2, or 3 characters, numbers on the right could be 1 through 999.

EE-emark.rpt

Could someone help me out?  Thanks!
Joel
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

It is a alphanumeric sort. You will have to break your field into 2 parts (being sure your second part is numeric) and sort on these new fields.
Avatar of Genius123

ASKER

I know that's what I have to do, but I don't know how to split it when one side is text and the other a number and both have variable lengths.
Would it be possible to split/normalize in your database? or would it be possible to format the number using a 000 mask?
you can also create a function in CR to remove the alphabetic characters. There is a sample similar to this on tips #2 from http://extranet.iteba.com/internet/docs/ITASOL095%20(Crystal%20Reports%20Hints%20and%20Tips).pdf
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect.  This worked like a charm.  Thanks!