I have a few decimal fields from a SQL table that I need to format in the script. The user does not want to see the decimals where the value is a round number. For example, currently a value displays as 100.00 and the user wants to see 100. However, if the value is 123.45, then I need it to display as 123.45. Can I handle this in the script or do I do it on the report?
Yes, We can achieve where you want. Would you provide real data to look
Hows your SQL decimal field values come through. Are they always two digits after decimal. May be you can try like:
IF(Subfield(Values, '.',2) = 0, Round(Values), Values) AS FormattedField