Dynamically Update Parameter List Box Based on Other Parameters

the.root

Hello, I hope this is an easy one out there for the community. While I know I'm just getting started with Birt and intend to really learn and read up on it; I kind of need some quick guidance on how to solve this present dilemma:

Say I have 4 Parameters

Param_A
Param_B
Param_C
Param_D

They are all listbox parameters with dynamic data set pointed to a simple jdbc/SQL query datasets. Each of these parameters ties to each other in some way through different queries. So whatever Param_A gets selected as, the remaining 3 parameters need to be updated to populate the valid dynamic dataset based on the one selected. I think I can figure out the SQL statements just fine, as far as joining, figuring out which ones are selected, etc. Also to note that none of these have to depend on each other, so I may only set Param_D, it may auto update the rest of the Param_$ but does not have to depend on the others previously being set. It's really a MANY > MANY relationship of the parameters, thus why I cannot use the Cascading Feature, as that is completely dependent of the child param and each parent directly above it. I guess my main thought on how to do this, and question brought to this thread is:

Can I make all of these separate parameters and then figure out a way to update the other listbox contents based on a selection of any? Is there some onSelection event handler or some easy way to deal with this? If anyone has any thoughts or suggestions on how to do the previous statement, or any other methods of achieving what I need - then please let me know! Bare in mind I'm not vary versed on Java/JS/Birt, so try not to make any assumptions when explaining something simple :-)

Thank you very much!

mwilliams

My initial guess is that you'll have to create your own custom parameter interface do this. I don't believe there's a way with BIRT's default parameter setup.