Solved

Reporting Services hide decimal point

Posted on 2009-03-31
2
1,368 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 27

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

729 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