Total row count value in Jasper Reports


How do I get the total number of rows returned from Oracle to be displayed in Jasper reports?


I have a SELECT query which returns 10 rows of data.

How do I get this count (i.e. 10) to be displayed in my report.

anthonyraj's picture
Joined: Aug 24 2009 - 2:24am
Last seen: 13 years 7 months ago

2 Answers:

I also need this row count in my report.

Do you got any solution or not?

jayashreep's picture
Joined: May 31 2012 - 5:49am
Last seen: 9 years 4 months ago

Use REPORT_COUNT built-in variable into a textField with attribute evaluationTime="Report".

You can use REPORT_MAX_COUNT parameter to limit the number of rows fetched.

I also use a textField with following expression:

$V{REPORT_COUNT}.intValue() == $P{REPORT_MAX_COUNT}.intValue() ? "Not all data could be fetched" : null</td></tr></tbody></table>
federico.cattozzi's picture
Joined: Sep 22 2009 - 4:34am
Last seen: 8 years 12 months ago