Hello,
I have designed a report with 9 columns, for one of the price column the values are in float and i need to change into decimal values Ex:when i run report ,the column values are 10.2222222 and i need like this 10.22 only two digits after point.
How can this be achieved.
I checked DecimalPlaces property of text box ,it is <2:2>…
plz help me on these…
Thanq advance
Which version of Navision you are using ?
Is it Classic Report or RDLC report. ?/
Hi,
Using Navision 2009 and designing Classic report through Section design.
Please help me.
I need to get a column like this
(Price - Cost) + line discount+Amount discount
i want this calculation Under section designer of classic report of Nav2009
Hi,
Select the TextBox Property then make DecimalPlaces to <2:2>
Go to SourceExpr : (Price - Cost) + line discount+Amount discount.
I have checked DecimalPlaces to <:2> it is correct…
is there anything i need to add
Plz reply me any body
Try to use ROUND( Var ,0.01) in source expression
Not <:2> but <2:2> - it means print the amount with a minimum of 2 chars after the decimal point and a maximum of 2 chars.
Round will give you another result, it’s not just cutting of the remaining chars.
Actually you should also try to change the existing “<2:2>” to just “2:2” - (remove the <>) - the <> just marks that it’s the default value. But I have seen examples where it made a difference.