Solved

Reporting Services hide decimal point

Posted on 2009-03-31
2
1,367 Views
Last Modified: 2012-05-06
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
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
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

by:ryanvb83
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

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…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question