Reporting Services hide decimal point
Posted on 2009-03-31
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?