Arthimetic operators in sql

0

Hi,

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

 

Thanks,

Jeevana

jeevanabattu's picture
Joined: Feb 25 2020 - 6:11pm
Last seen: 4 days 14 hours ago

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.

tchen - 1 month 4 days ago

0 Answers:

No answers yet
Feedback
randomness