Using Multi-select parameter in Jasper
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
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
step4: Using the parameter in the query. following is the syntax for using multi-select parameter in a query.
Best Open Source Business Intelligence Software Helical Insight is Here
A Business Intelligence Framework