Procedure / plsql support in jasper report

I am not very sure from which version Jasper started supporting this feature, but recently when I was evaluating 3.7.5 version I suddenly explored this... and it is so easy...!

Well here it is how...  when you write a query in the querystring tag, Jasper has added a property called "language" and here it supports for different languages querystring. so for calling a procedure from jasper report

Read More

creating a crosstab report with jasper report

creating a crosstab report with jasper is became very easy task now... as I explore it I found it very easy and simple to do... the most tedious task was earlier to manage with the query to get the data in cross format. since there was no alternate or easy feature available from database either. but for now with japserreport it become so easy that you don't have to modify your query at all just

Read More

creating jasper sub-report using iReport

creating a sub-report example with Jasper

Pre-requisite: I assume that you know how to create normal reports using iReport GUI tool also basic knowledge of database, sql with MySql.

before we start with actual creating of report lets understand the database that we require.
following is the table structure that we require.

I have taken the sample database that comes with iReport hsqldb, you

Read More