Aggregation in charts

sirim

Hello Everyone,

I am generating the report which has four data sets displayed with four tables.The table has an aggregation tool which contains the count of all in rows in table.
I need to use these totals to be dispalyed in the chart. Is this even possible in BIRT?

I tried creating a chart, however in Select Data -->Inherit Data from Container --> Data perview is empty. Hence I am not able to drag any column from there.

Any help would be useful.

Thank you

johnw

Take a look at the attached report. In it, I have 4 tables, each with an aggregate of total sales by country (its actually one data set with a filter at the table level, but its the same as 4 different data sets for this example).

In the onCreate of the aggregate component (this could be on the table itself as well), I am calling a global function that adds the total sales value to a HashMap, keyed by the country (see the reports initialize function, which contains the global functions definition).

I created a scripted data source that pulls its values from this HashMap. The Scripted Data Source and HashMap basically tie the aggregations of all 4 tables together into one logical data set. I then created a chart using this data set as its source.