Arthimetic operators in sql

[jeevanabattu]

Hi,

Can we use arthimetic operators(+,/,>=) in SQL query in jasper studio.

 

Thanks,

Jeevana

[Tom C]

Whatever syntax that your database supports, it should work in query based report created in Jaspersoft Studio (JSS). Check with DB query reference manual and/or consult with your query experts first, and use a DB tool such as squirrel-sql to test your query using the same JDBC driver as you use in JSS to make sure it works. Then use this query in JSS to get your report data.