Couple of questions (looping query)

al91206

Hi,

We are using Birt 2.3.2

We have an environment which uses different database for each client. Everything else is the same though - tables, columns, etc.

We currently have a parameterized query that prompts users to get the client and changes the DB the query uses. This is done using: this.queryText in beforeOpen.

However, we need a couple of different methods if possible.

1. We would like to be able to have a user select multiple clients. So it would be getting data from Table1 in databases Client1 and Client2, etc (whatever the user selects).

2. We would also like to be able to have an "All" function so it grabs all available clients.

We do have the client list in a table - which is how I come up with my prompted parameter pages.

Any help on this is appreciated. We know this is not a great way to have this setup but there is a long-term project to change it.

Thanks,

Al