get Total number of records retrieved

Hi All,

I want to show the total number of records retrieved at the bottom of every page of the report. Please help me. Any sample would be helpful.

Find more posts tagged with

Comments

mwilliams

Hi zkhalid,

What version of BIRT are you using?

zkhalid

using BIRT 2.3.2. Got it on header of page using Total.count() but now needs it on page footer.

mwilliams

zkhalid,

Here's an example that shows a couple different ways to do it. You can make a computed column in your first dataSet that does a COUNT aggregation and display that in the master page footer. The other way that this example shows is to create a second dataSet with the same query that just returns a count. Then, you can use this value in the master page.

This report was designed in BIRT 2.3.2.2.