Number to String in a formula field for SAP Crystal Report

 Number to String in a formula field for SAP Crystal Report



For example,

 1. If you want values 10 and 8.5 to be shows "10.00 - 8.50".

     The formula you will use 


    CSTR({field1}) + " - " + CSTR({field2}).


2. If you want values 10 and 8.5 to be shows "10 - 8.5".

     The formula you will use 


    CSTR({field1},0,'') + " - " + CSTR({field2},0,'').