Skip to Content
0
Nov 22, 2019 at 05:49 PM

Sort based on Specific String

59 Views

Hello All,

I have a field that Contains Pick and drop string only. This string is based on name and Time. The pick has time whereas Drop has a null value of time. I am wondering how to sort in Crystal Report.

My sort order should be like

Time asc, Pick/drop like

600 - pick - Name A

-Drop - Name A

700 - Pick -Name B

- Drop -Name B

and so on

My challenge is; If I sort by time, all picks come together because they have time value and If I sort by name, time gets unsorted. Please advise I would appreciate your help. Thanks