Number of rows in a table

I am fairly new to BIRT. I am trying to generate a report using JDBC Data set and SQL query .

The output of the report is displayed in a table. I need to count the number of rows that are displayed when the query is excecuted. Is it possible to count the number of rows in BIRT.
The special condition is, the result has some rows which are to be excluded, can we apply any condition while counting the rows to exclude them.

Thank you for all your help.

Find more posts tagged with

Comments

pricher

Hi,

I have attached an example where I included an aggregate, CountCustomers, in the footer of the table. The aggregate uses the COUNT function to count the number of rows and a filter to only count customers in Canada.

Hope this helps,

P.

sirim

<blockquote class='ipsBlockquote' data-author="'pricher'" data-cid="97434" data-time="1331216401" data-date="08 March 2012 - 07:20 AM">
Hi, 
 
I have attached an example where I included an aggregate, CountCustomers, in the footer of the table. The aggregate uses the COUNT function to count the number of rows and a filter to only count customers in Canada. 
 
Hope this helps, 
 
P. </blockquote>

sirim

Thank you Pricher,
I was able to slove my issue.

It was a great help.