pkhalwadekar Posted July 8, 2015 Share Posted July 8, 2015 I provide an input parameter of 1.5561 to a report and it rounds it to 1.556 using Big Decimal as the class type. I want the input parameter to always be upto 4 places. This input value is further used in an SQL query and since it considers 1.556, the output of the report is wrong.Please help!! Link to comment Share on other sites More sharing options...
hozawa Posted July 8, 2015 Share Posted July 8, 2015 It' seems to a "is for prompting" bug. If you set it to "false," precision remains intact.As for now, you'll have to get the value as java.lang.String and use the String in the SQL statement. Link to comment Share on other sites More sharing options...
Tom C Posted July 8, 2015 Share Posted July 8, 2015 This is just a limitation on parameter scale in Studio preview UI. When running this report from JasperReport Server or from your application using JaspeReports library, you should be able to provide input numeric value with the scale as you wish, providing your MSSQL colume scale is the same to have the correct query selection. Link to comment Share on other sites More sharing options...
Tom C Posted July 8, 2015 Share Posted July 8, 2015 Thanks for bringing this issue to our attention - our developer will fix this in the next Studio version release. Link to comment Share on other sites More sharing options...
Tom C Posted July 8, 2015 Share Posted July 8, 2015 Thanks for Hozawa's suggestion - yes, you can use String parameter instead to work around the problem. Link to comment Share on other sites More sharing options...
pkhalwadekar Posted September 7, 2016 Author Share Posted September 7, 2016 @tchen: Is this version released? How will this handle in Jasper Server? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now