• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1382
  • Last Modified:

Reporting Services hide decimal point

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
ryanvb83
Asked:
ryanvb83
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
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
 
ryanvb83Author Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now