OpenText technical experts collaborate with supported customers and partners in the Magellan product area.
Enabling or disabling a Report Parameter dynamically
Although I am comparatively new to BIRT I have created few reports in BIRT. Right now I am facing a problem of how to enable or disable a report parameter dynamically. I would highly appreciate some help in achieving this functionality in BIRT Designer. I am using BIRT Designer 2.5.2.
The functionality I am looking for is as below:
1. The user would have to select an option from a dropdown. Each option in the dropdown has a SQL query associated with it with each one of them needing additional input parameter(s).
2. What I want to do is depending on what is selected in the dropdown mentioned in Step 1, I want to show additional parameters. For example, if the query needs "number of days" I would like to show the user a textbox and have them enter a number. Or if the SQL query needs a "start" and an "end" date I would like to show two textboxes to enter the "start" and "end" dates.
I have figured out how to change the query dynamically in beforeOpen of the DataSet. It's a basically a bunch of if-else statements. I also have figured out how to build the result table at runtime as each query will have different output. I am doing this in beforeFactory of the report.
I have successfully done it for the queries that do not need additional input parameter(s) but not sure how or whether it is possible if I need to provide additional parameters for query at runtime.
Any help will be highly appreciated. Thank you.