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.
Posted on June 18, 2012 at 2:01am
I also need this row count in my report.
Do you got any solution or not?
Posted on June 18, 2012 at 7:40am
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: