• soldout6000 - Tuesday, April 24, 2018 10:38 AM

    Steve (SSC Guru),
    Thank you so much for your feedback. Yes, I needed to round the numbers because they were too big to fit in.
    This resolved the issue and I'm able to display the values on my ssrs report.
    Thank you once again for your help!

    Glad I could help out.   Just to be sure you understand, if you round a number down on decimal places, you are going to lose accuracy on that number, and it's not a problem that can't be solved.   Just go ahead and CAST it to varying character on the Oracle side, and CONVERT it to a large enough decimal data type on the way into SQL Server.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)