Last post Apr 22, 2012 01:11 AM by Ashutosh Pathak
Apr 20, 2012 04:26 PM|MyronCope|LINK
using Sql server 2005 and VS.Net REport Proj 2005
I am returning a field from a table that is type money and displaying on a textbox on a report.
when I run the query in the stored proc I get a value like: 5.00
However when it displays on the report it displays like: 5.0000
how do I correctly display a money field on a report so it only shows down to the penny level?
Apr 20, 2012 08:42 PM|olivespike|LINK
Open your report in designer. Right click on the column field. Select TextBox Properties. Select Number from list on left; select currency from catagory options; make sure Decimal Places is set to 2.
Apr 22, 2012 01:11 AM|Ashutosh Pathak|LINK
you can use Math.Round function in such case, a simple example is below for the textbox expression: