Display Amount in Single TextBox

basic0220

Hello Guys,

does anyone here knows how to display Amount in single text box?

I mean,
I have this set of fixed text boxes in my report layout.



and I'm currently using the expression =mid(First(Fields!txtAmount.Value,"DataSet_Result")2,1);
which explains the 4 on the first text box.
it should be like that.

It should fill all text box in proper format regardless if the amount is 10 100 10,000 100,000 1,000,000


my output for the screenshot is currently.
24.86.

I didn't include the "."n the expression because it is already given.

I'm hoping to get an honest answer.
Thank you everyone.

cheers!