Page 1 of 1
Format Property not working
Posted: Tue Apr 26, 2022 10:18 am
by rrandall
Hi,
The Format property in the reports designer does not seem to work for hash cookies. Is there any way around this?
Designer:
design.png
Report:
report.png
Re: Format Property not working
Posted: Tue Apr 26, 2022 11:35 am
by kev1n
Hi,
I am not sure if a format is applied to labels at all. How is the Hash Cookie set? Maybe you can format it differently (by SQL, JS )
Re: Format Property not working
Posted: Tue Apr 26, 2022 2:24 pm
by rrandall
Thank you kev1n, that got me on the right track. The Hash Cookie is set in Javascript. I got it formatted correctly by simply setting the Hash Cookie using the value returned from:
Code: Select all
Math.round(stmt_opening_balance * 100) / 100).toFixed(2)