multiple charts in a table using the same dataset?

jsherriff

I have two data sets, one that generates a list of ids, and one that takes an id param and returns a dataset for a chart. I've created a table with the first dataset where each row contains a chart which uses the second dataset...and I'm trying to parameterize the second dataset's query to pass in the row[] element from the first dataset, but it never works. I always get multiple duplicate charts - it's obviously only generating the 2nd dataset once, even if I change the param via reportContext.setParameterValue()

Is there a way to make this work?

Virgil

Hi jsherriff,



Have you tried using the Dataset Parameter binding? (Select the chart, and then the binding tab to see this) You should be able to select the detail row value from there that gets passed back to the data set parameter. There is an older example of having nested charts here:

http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=84



and a newer example that uses parameter binding located here:

http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=337