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