jaspersoft studio query parameter not found

In the properties section on the right hand side corner of the report, go to parameters option(2 nd last option in ireport). This is how Jasper understands and therefore allows the data to flow into the subreport.ģ. Go to the main report and click on the subreport band. For example: If the name of main report variable is X with datatype then the subreport should contain the same parameter of X with datatype. So we have to create a parameter on the subreport side which will have the same name as the name of the field/variable on the main report and the datatype should be the same also. The rule is, for every field(be it either a variable/a query field/ a parameter) we want to pass to a subreport, a similar parameter (with another name) has to exist in the subreport, so that we can make the mapping. We will get these parameters by passing them from the main report to the subreport. Now the link has been established between the main report and the subreport.

Connection Type: Use a connection expressionĬonnection Expression: $PĢ.

Subreport Expression: “repo:/public/MainReport/Subrpt.jrxml” à Subreport path.

You now have to link the subreport element that you just added to the main report, to your subreport file (the one you created in step 1) In order to do that, select the subreport element in the main report, and modify its parameters as follows: For example: Let the name of the main report be Main.jrxml and the subreport be Subrpt.jrxml.

First thing is to create the subreport and link the subreport with the main report.

The main things that we need to take care of are the datatype and the naming convention. In those cases we need to pass those values as parameters to the subreport which in turn can be used in the subreport. The values can be either the parameters used to call the report, variables or can be the fields generated from the query. In some cases, there are some values which needs to be used both on the main report and the subreport. This functionality helps us during complex designs where the data comes either from different portions of a single document or from different datasources. A subreport is a report which is used inside another report. Before going into details, let me tell you what is subreport and what is the relation between a main report and subreport.

Jaspersoft studio query parameter not found