Using Multi-select parameter in Jasper
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
Parameters can be the filter conditions which can be applied in the data-visualizations. This blog gives steps wise description of creating a multi-select parameter while developing report.
There are 2 different types of Parameters
1. Single select
2. Multi-Select
Creating Parameter in Jasper Studio:
For Example there are employees in a department and a report generates the employee details department-wise. If the user wants to view employees from more than 1 department user can create multi-select parameter in that case.
Following are steps to create a parameter
step1: In the outline to the left side of the jasper studio we can find parameters. Right-click and create a new parameter.for eg: lets create a parameter with name “dept” and in the class definition we must give “java.util.Collection”, we can also give default values it is optional.
step2: In case we are using sub-report or the table component we need to pass the same parameter with same name to the sub-report/table. In the above example we are using table. Click on table in the table component and in the properties pane select dataset table u will find the following
step3: Then add the parameter from main report to the table/subreport.
and click on finish.
step4: Using the parameter in the query. following is the syntax for using multi-select parameter in a query.
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
where $X{IN,d.department_id,dept}
Best Open Source Business Intelligence Software Helical Insight is Here
A Business Intelligence Framework
Thanks
Asha Bidiyasar
Hello, I am relatively new to JasperSoft and would like to create a multi-select parameter in my report. I am not seeing in your example where I can set up the parameter itself to be multiselect, i.e. where the user can click on multiple options in the list. Is there a way to do this in the UI? Thanks!