| Change values of a dynamic parameter based on the value of another parameter [message #772484] |
Thu, 29 December 2011 17:23  |
Eclipse User |
|
|
|
I have a dynamic parameter that get values from a database, with a query like the following :
SELECT cod, des FROM table
the cod field is bound to the combobox value member, while des field is bound to the combobox display member.
I want to change the values displayed on the combobox based on the value that the user assign to another parameter, for example :
param1 ---> DateTime
param2 ---> Dynamic Parameter based on the param1 datetime value
so, when the user change the datetime value on param1 the query bound to the param2 dynamic parameter should be executed again in this way :
SELECT cod, des FROM table WHERE date = params["param1"]
an the values on the combobox should be updated with the new resultset of the query .
Is it possible with BIRT ?
|
|
|
| Re: Change values of a dynamic parameter based on the value of another parameter [message #774352 is a reply to message #772484] |
Tue, 03 January 2012 13:55  |
| Eclipse User |
|
|
|
Yes but you have to use a cascaded parameter. Look at the attached
example.
Jason
On 12/29/2011 5:23 PM, Alessio Pollero wrote:
> I have a dynamic parameter that get values from a database, with a query
> like the following :
>
> SELECT cod, des FROM table
>
> the cod field is bound to the combobox value member, while des field is
> bound to the combobox display member.
>
> I want to change the values displayed on the combobox based on the value
> that the user assign to another parameter, for example :
> param1 ---> DateTime
> param2 ---> Dynamic Parameter based on the param1 datetime value
>
>
> so, when the user change the datetime value on param1 the query bound to
> the param2 dynamic parameter should be executed again in this way :
> SELECT cod, des FROM table WHERE date = params["param1"]
>
> an the values on the combobox should be updated with the new resultset
> of the query .
>
>
> Is it possible with BIRT ?
|
|
|
Powered by
FUDForum. Page generated in 0.08150 seconds
Home