Good Day All,
I have a field called TranNo which is a number. Then numbers are random (1,3,6,8,99)
In my sort I want to Sort Ascending, but I want the 3 to be at the bottom of the sort..
1 first followed by the 6 then 8 then 99 then 3s.
I wrote a forumla but Crystal doesn't like it.
if {vrcGGP_ContDiary.TranNo} = 1 then Cstr({vrcGGP_ContDiary.TranNo}) = 'A'
else if {vrcGGP_ContDiary.TranNo} = 3 then Cstr({vrcGGP_ContDiary.TranNo}) = 'Z'
else if {vrcGGP_ContDiary.TranNo} = 6 then Cstr({vrcGGP_ContDiary.TranNo}) = 'B'
else if {vrcGGP_ContDiary.TranNo} = 8 then Cstr({vrcGGP_ContDiary.TranNo}) = 'C'
else if {vrcGGP_ContDiary.TranNo} = 99 then Cstr({vrcGGP_ContDiary.TranNo}) = 'D'
else Cstr({vrcGGP_ContDiary.TranNo}) = 'E'
Error ****
The Formula result must be a string
Kind Regards,
Dmarz96