As I need to provide different databases for different stages (development, testing, production) I configured my data source dynamically using the „property binding" to set the db-host, password and user.
This allows me to pass a parameter which sets the correct values for the stage. This works for most of my reports.
But in some reports I also need to add dynamic parameters, which is filled by of data from the db and provides a dropdown box for the user to select certain kind of information.
I run into the problem, that this drop down menu is always empty. I far as I can see this happens because the paramters for the database are not set when the dialog is opened, so the query for the drop down menu data fails.
Is there somethign I can do to bring up the data in the drop down box even if I am using the property binding to set the value for the db connection?
Unfortunately I need to use this DB as the values for the drop down list must be read from the stage db.
I am quite new to BIRT so I am not sure whether I really understand what happens. When the datasource is static everything works fine and the values (for the drop down list) can be read from the DB before the dialog is openend.
I my report I am using the following script to initialize the db connection parameters. But I feat his is too late for the paramters dialog. Is there a way to invoke this script early? Before the parameters dialog is shown?
For these reports, you might have to create two levels of reports. The first one takes the connection parameters and then you create a parameter form, using HTML text boxes, in the layout, allowing the user to select the parameters. Then, from this report, you call your actual report, passing along the selected values.
My problem is kind of similar.
You have suggested "Then, from this report, you call your actual report, passing along the selected values."
Could you please tell me how to do this?I am unable to pass the selected values and call the actual report.
I don't want to use "report parameter" neither call an url.
Please help me.