Hi everyone,
I have encounter one problem which is i don't know how to set the amount into 2 decimal places in report layout.
My problem is how to make the highlighted amount(yellow color) into 2 decimal places same as the amount decimal (red box)? For the first column, line amount column, it able to generate 176.00. So, there is no problem for the decimal places.
But on the other hands, when there is zero amount in the 2nd column and 3rd column, the decimal places will not shown in 2 decimal places.
So, where i should make changes and set it as 2 decimal places.
Thanks.
*This post is locked for comments
You can set the expression as
=Format(Fields!abc.Value,"F2")
If you are talking about report, in the layout section, click the field and there should be a property called Format. You can assign it with a field (format.value field) or write a fixed format yourself.
Go to the Report Designer.
Select the field, right click on field.
Choose TextBox Property
Now choose Number from left side pannel and then choose your the formating what you want.
After OK, save/compile and run the report.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156