Eclipse Community Forums: BIRT » Change values of a dynamic parameter based on the value of another parameter

Home » Eclipse Projects » BIRT » Change values of a dynamic parameter based on the value of another parameter(dynamically change values of a parameter )

Show: Today's Messages :: Show Polls :: Message Navigator

Change values of a dynamic parameter based on the value of another parameter [message #772484]

Thu, 29 December 2011 17:23

Alessio Pollero
Messages: 65
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 ?

Report message to a moderator

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

Jason Weathersby
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 ?

Attachment: cascadeexample.zip
(Size: 4.01KB, Downloaded 62 times)

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	Problems using WebViewerExample
Next Topic:	Problem with starting application after eclipse + birt update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 04:44:18 EDT 2013