Rounding off values

I am working on SSRS-2005. This must be easy for wiz, how do you round off values corrected to two decimal places in reporting services?
Is there a VB expression which i can write on format>fx tab  in the value fields.
shobhitdixitAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rettiseertCommented:
VB has the FormatNumber fucntion:

FormatNumber(1.545,2)

will round 1.545 to two decimal places
0
digital_thoughtsCommented:
SQL Server has a round function ROUND(FieldName, 2) 2 being to two decimal places.
0
brejkCommented:
In Report Designer in Visual Studio being in Layout tab select the field (or multiple fields) for which you want to make round off. In Properties window go to Format property and set its value to N2 (or C2 if you want currency).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

shobhitdixitAuthor Commented:
In Report Designer in Visual Studio being in Layout tab select the field (or multiple fields) for which you want to make round off. In Properties window go to Format property and set its value to N2 (or C2 if you want currency).
--Brejk

Thank you all for your quick response. But how do i round to the nearest value.
0
brejkCommented:
Well, I tried - if you set the Value property of the field to:

=CDec(<put_the_number_here>)

and then you set the Format property of the same field to N2 the number will be rounded.

Example: 123.1250 -> will be rounded to 123.13
0
shobhitdixitAuthor Commented:
I don't know how to achieve this:


I want something like this:

1234.56
1235
0
PFrogCommented:
In the report, set the format property of the textbox to 0

You can also display 1,235 by using the format #,##0

Or 1235.6 by using the format 0.0
0
shobhitdixitAuthor Commented:
All the solutions were correct. N0 worked for me.

Thank you all for your valuable time.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.