Genius123
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
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. This worked like a charm. Thanks!