Report with rows of data followed by a chart

[atiquek]

Hi All,

I am using Custom Data Source to fetch data to create a report wherein I have a detail section which displays data in a tabular format followed by a custom chart in the summary section. The tabular format is

Date                      Item1 Count                         Item1 Count      Item3 Count

01/03/2012          35                                           45                        52

02/03/2012          55                                           25                        58

03/03/2012          45                                           45                        65

The chart is supposed to display this data in a bar chart with three series for Item1, 2 & 3. I understand the main query could not be used for the chart. I have modified the data to be a JRCollection like

Date date; String item; Integer count; so that item can be used a series, date as category and count as value.

Could someone please advise how can I pass this bean to the chart. One thing to note this is implemented using Custom data source and the data can be retrieved only once using custom data source and passed along to the chart.

Thanks,

Atique

Post Edited by atiquek at 04/08/2012 09:11

Post Edited by atiquek at 04/08/2012 09:12