I am using Crystal XI, Oracle database.
I have a list of AT codes that should take priority when a person has more than one record (i.e. they have more than one AT code).
AT CODE PRIORITY
FTB takes priority over XBB, XTF, XCC.
MBB takes priority over MTF.
MTF takes priority over MCC and WRS.
DATA
ID AT Code
11111 FTB
22222 MBB
22222 MTF
Output should be:
ID AT Code
11111 FTB
22222 MBB
Thanks.
I have a list of AT codes that should take priority when a person has more than one record (i.e. they have more than one AT code).
AT CODE PRIORITY
FTB takes priority over XBB, XTF, XCC.
MBB takes priority over MTF.
MTF takes priority over MCC and WRS.
DATA
ID AT Code
11111 FTB
22222 MBB
22222 MTF
Output should be:
ID AT Code
11111 FTB
22222 MBB
Thanks.