Skip to Content
0
Former Member
Jan 19, 2012 at 03:41 PM

Convert a number field to a string fields for sorting

341 Views

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