Total row count value in Jasper Reports

[anthonyraj]

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.

[jayashreep]

I also need this row count in my report.

Do you got any solution or not?

[federico.cattozzi]

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