the one that you want to do is: create a field then set this as prompt so the user may input his/her variable everytime then use this formula: set the two to double not integer in case of deciaml. then set to display 2 decimal places. new Double($F{field1}).doubleValue * new Double($F{field2}).doubleValue - this is your varialbe then formulathen set the variable calculation to nothing.
new > database JDBC connection > then change url to dbc:mysql://'your ip'/'your database' server address: your ip database: 'your database' username: 'username' password: "password" test connection password using yes @ bla blah. it means the database is protected by password / the inputted password is incorrect. k?
Welcome to jasper Forums cdavis74, this is my first post too :) What you need to do is to do it in SQL LEARN TO GOOGLE: SQL DATE IN BETWEEN or datefrom=><= dateto + karma is appreciated ^^ Post Edited by notrolls at 02/01/2011 06:14