Displaying total count of resultset on Reports

Hi,

I'm designing custom reports with some criteria.For each report I want
the total count of workitems to be displayed below the chart that meet
the criteria.

For example, I want a total count of workitems reopened within a
period of time. I'm using Workitem_Chngs to get it. Though I'm able
to generate a bar chart for this, I'm unable to display the total
count on my report.

I may be missing something. Please suggest.

Thanks,
Bharath

On 12/7/2009 10:08 AM, littleheartb4u wrote:

Have you tried using a dynamic text element, binding it to your data
set, and then using one of the "Total" aggregation functions to
calculate the value that you're looking for?

james
RTC Reports Team Lead

jmoodywrote:
On 12/7/2009 10:08 AM, littleheartb4u wrote:

Have you tried using a dynamic text element, binding it to your data

set, and then using one of the "Total" aggregation
functions to
calculate the value that you're looking for?

james
RTC Reports Team Lead

James, thanks for the reply. I used Total.count(). This gives the
count of rows in the result set. What if I want to get total of one
particular column in the result set?

Thanks,
Bharath

Rafik, James thanks a lot. Also, can you please point me where I can
find all the aggregate functions of Total?

Thanks,
Bharath

On 12/13/2009 8:08 AM, littleheartb4u wrote:
I see some documentation here:

http://publib.boulder.ibm.com/infocenter/radhelp/v7r0m0/index.jsp?topic=/org.eclipse.birt.doc/birt/birt-24-4.html

Let me know if this isn't what you're looking for.

james
RTC Reports Team Lead