Loop through list values and generate dynamic tables and charts

ekalavya

Hi,

I'm a newbie to Birt Reporting. I have generated few basic reports till date. But this time I was trying to generate a dynamic table and charts depending on a multiselect list box values.

Suppose,

1. My list of input "keyword" consists of "[virus, torrent, terrorism]"
2. I have a basic design ready with a table and a chart, dataset, parameters.
3. I need to append them to the same page as a new set the of same basic table and chart with different query depending on keyword values.

I have idea that I can add scripts and manipulate things like -

1. Loop through list values.
2. I can modify query.

But no idea how to replicate table and chart data and dynamically create and add data set to them.

I've attached a file, which will help you to understand my requirement. Please somebody help me ...

Thanks in advance

kclark

You want to have the report generate based off of the parameters? Have you taken a look at the cascading parameters in the example in BIRT yet? By using cascading parameters it will pull back update your query and pull back the data that the user has selected, filtering everything out. To see the example go to Window > Show View > Other > Report and Chart Design > Report Examples.