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