So I have a report with two parameters which are floats. 2-3 digits long. I need a decimal point before the last digit for it to render properly. But I am having trouble formatting it.
I try formatting but it doesn't put the decimal before the last digit.
Thanks in advance !
Figured it out. This is how I query the DB and it works.
SELECT wastewaterlog.FlowRate / 10 AS FlowRate, wastewaterlog.GrandTotal, wastewaterlog.Past15MinFlow / 10 AS Past15MinFlow, wastewaterlog.t_stamp FROM wastewaterlog