Total row count value in Jasper Reports

0

Hi,

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

Scenario:

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: 9 years 11 months ago

2 Answers:

0

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: 5 years 8 months ago
0

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:

Code:
$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: 5 years 3 months ago
Feedback
randomness