Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Change values of a dynamic parameter based on the value of another parameter(dynamically change values of a parameter )
Change values of a dynamic parameter based on the value of another parameter [message #772484] Thu, 29 December 2011 22:23 Go to next message
Alessio Pollero is currently offline Alessio PolleroFriend
Messages: 66
Registered: August 2011
Member
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 18:55 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 ?
Previous Topic:Problems using WebViewerExample
Next Topic:Problem with starting application after eclipse + birt update
Goto Forum:
  


Current Time: Fri Dec 19 18:12:47 GMT 2014

Powered by FUDForum. Page generated in 0.02490 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software