Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Enabling or disabling a Report Parameter dynamically
Migrateduser
<p>Hi,</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>The functionality I am looking for is as below:</p>
<p> </p>
<p>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).</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>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.</p>
<p> </p>
<p>Any help will be highly appreciated. Thank you.</p>
Find more posts tagged with
Comments
There are no comments yet