Parameterized Report That Repeats a Set of Queries Based on Multiple Selections

uptimeken

1. Let's say a report has an input called "City".
2. Let's say I've created a chart that uses parameterized query to pass the input city to the query and return the number of boats in the city. So if I pick toronto the number of boats on a single chart on a single page is 100.
3. Let's say now I want to let users select multiple cities, and just have the layout of the report just repeat over and over. So instead of just doing the query once and getting the specific number of boats for the one city. If the user picks (toronto, montreal) I want there to be 2 identicle charts, just one that shows for toronto and one for montreal. If I pick 3, 4, 5.... I get 3,4,5 charts one after another for each city I chose.

Sorry if this is a newbie question.

Currently if I modify the input parameter to allow multiple selections I just get a bunch of exceptions for the datasets.

Thanks

mwilliams

Hi uptimeken,<br />
<br />
Take a look at this example from the devShare for using multiple select parameters:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause/#description'>Using a Multivalue parameter in a in clause - Designs & Code - BIRT Exchange</a><br />
<br />
Let me know if you have questions.