Total row count value in Jasper Reports

Posted on September 1, 2009 at 6:35am

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

Joined: Aug 24 2009 - 2:24am

Last seen: 13 years 7 months ago

2 Answers:

Posted on June 18, 2012 at 2:01am

I also need this row count in my report.

Do you got any solution or not?

jayashreep

220

Joined: May 31 2012 - 5:49am

Last seen: 9 years 4 months ago

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:

Code:

$V{REPORT_COUNT}.intValue() == $P{REPORT_MAX_COUNT}.intValue() ? "Not all data could be fetched" : null</td></tr></tbody></table>

1576

Joined: Sep 22 2009 - 4:34am

Last seen: 8 years 12 months ago