nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Filter for Multi Select input parameters

birtdeveloper

Hi,
 
I am new to BIRT report development. I am using the BIRT eclipse verison to design a report. I wish to have 3 Multi Select report parameters to be prompted to the user before the report is run.
I understand that we could use the Combo Box for report parameters, but this works perfect for single values, and not for multiple selections for a drop down.
 
I am attaching the screenshot of how the report parameter looks like.
I have a parameter called param1 which I want to prompt to the user. He can choose one or more values for this parameter. And based on this selection, I want the report to run. 
 
Any help will be appreciated.

Find more posts tagged with

Comments

pricher

Hi,
 
In the parameter definition, choose List Box instead of Combo Box and check the Allow Multiple Values property, as shown here:

birtdeveloper

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="141926" data-time="1453844587">
<div>
Hi,
 
In the parameter definition, choose List Box instead of Combo Box and check the Allow Multiple Values property, as shown here:
 
<img src="http://developer.actuate.com/community/forum/public/style_images/developer_actuate_images/attachicon.gif" alt="attachicon.gif"><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?app=core&module=attach&section=attach&attach_rel_module=post&attach_id=12713'>Snap 2016-01-26 at 16.41.45.png</a>
 
Hope this helps,
 
P.
</div>
</blockquote>
 
Hi Pricher,
 
Thank you for the prompt reply. I am currently using the open source BIRT eclipse version, and it seems that this option is not available in the open source version.
Can you confirm if you were able to find this option in the open source version, or did you buy the professional version?

pricher

Hi,
 
I just realized that the Allow Multiple Values option is not available when you create the report parameter from the data set parameter. It is only available when you create the parameter directly from the Report Parameters section in Data Explorer. This UI limitation is probably because BIRT doesn't handle nicely multi value parameters in queries. In fact, if you want to pass multiple values to a where clause, you will need to add some script to the beforeOpen method of the data set. 
 
I am sendng you a report sample where I have created 2 multi-value report parameters. The Data Set query is modified in the beforeOpen method based on the value of these parameters.
 
Hope this helps,
 
P.

birtdeveloper

<blockquote class="ipsBlockquote" data-author="pricher" data-cid="141982" data-time="1453907889">
<div>
Hi,
 
I just realized that the Allow Multiple Values option is not available when you create the report parameter from the data set parameter. It is only available when you create the parameter directly from the Report Parameters section in Data Explorer. This UI limitation is probably because BIRT doesn't handle nicely multi value parameters in queries. In fact, if you want to pass multiple values to a where clause, you will need to add some script to the beforeOpen method of the data set. 
 
I am sendng you a report sample where I have created 2 multi-value report parameters. The Data Set query is modified in the beforeOpen method based on the value of these parameters.
 
Hope this helps,
 
P.
</div>
</blockquote>
 
 
Hi Pitcher,
 
This is awesome. Thanks it helped!
 
Harsh.

RaviK

Hello Team,
 
Can you help me to provide the sample report which contains data set having the dynamic filter(Multi valued filter- values retrieved from other Data set )? I am using the FastDB for Data storage. so please do the needful to provide the reports with Data sources created using FastDB
 
Thanks,
- Ravi