i have a field retrieved from database with values like
BPV1, BPV2, ... CPV1, CPV2...,
where printing report the sorting comes in such manner :
BPV1,
BPV10,
BPV100,
BPV11,
CPV1,
CPV2...
and so on.
how can i sort it according to numerical sorting (ascending) in crystal reports as
BPV1,
BPV2,
BPV3,
BPV10
BPV11,
BPV20,
CPV1,
CPV2,
and so on