Skip to Content
0
Former Member
Dec 02, 2009 at 05:17 PM

Number to string conversion

41 Views

Hi All,

I have a requirement where I need to display as "N/A" for balance amount fields in our reports. So, I tried using cstr function for number to string conversion so I can display where the balance fields has NULL values in DB.

Now, I need to display the number of decimal places for this field depending on another DB field. Also, if the DB field value has '-' sign, I need to display the -ve sign on the right of the field in the report.

Please suggest as how this can be achieved.

Thanks

Naresh