hello_34 Posted June 7 Share Posted June 7 I am using jasper report 8.0.2 and I have created an adhoc view. In there In the measurements, I am going to create a calculated measure. In the formula, I am trying to convert a double to an integer and I cannot find a relevant build in function. As shown in the image where A , B is an integer C is a double. SO I want to get the output as Integer. Can someone help me? Link to comment Share on other sites More sharing options...
andrew_50 Posted June 7 Share Posted June 7 I think it would work if you did something like this in the SQL for your report... SELECT CAST( (`A` + `B` / `C') AS INT) 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