Solved

# Reporting Services hide decimal point

Posted on 2009-03-31
1,367 Views
I have a calculation in a group header that returns a number with 2 decimal places.  I want to simply remove the decimal from the value of that box.  I'm using this report as input into a mainframe and it does not accept decimal points.  For example, if the value of my box is currently "100.00", I need it to show "10000".  I've tried replace() and that worked but it truncated all zeroes after where the decimal point used to be.  For numbers like "19.99" it works fine because it returns "1999".  But, for numbers like "19.90", it returns "199".  Any ideas?
0
Question by:ryanvb83
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 26

Accepted Solution

Chris Luttrell earned 500 total points
ID: 24032087
Multiply your number by 100 first.  Then either use your replace() trick or see if you can format the field with F0 for fixed no decimals.
0

Author Closing Comment

ID: 31564977
It's been a really long day.  I figured it was something simple that I was overlooking.  Multiplying by 100 fixed it...obviously.  Thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Simple Linear Regression
Introduction to Processes
###### Suggested Courses
Course of the Month8 days, 21 hours left to enroll