How to define query in JasperReports Server

By Atul Rai | Last Updated: July 23, 2018 Previous       Next

In this example, we are going to explain how to define the query in JasperReports Server. Most of the time we put all the query in .jrxml file but here we can also define the query in the JasperReports Server.

Defining the query in JasperReports Server is totally independent of report query. You can manage it anytime and modified it according to need.

Check the below steps to define the query.

Note: Do not add the query in .jrxml file.

Step 1: Design your report, compile it and make sure there is no compilation error in the report.

Step 2: Click on the View » Repository and expand the root folder, select Reports folder.

Step 3: Right-click on the Reports folder and go to Add Resource » JasperReports .

Step 4: A new page will open, fill the required details and browse the report .jrxml file.

Step 5: After filling the details, click on the Query tab » Click here to create new Query.

Step 6: Fill out the name of your Query and click on Next button.

Step 7: Link the Data Source to the Query.

Step 8: Select the query language and define the Query.

Step 9: Click on the Save » Submit button and run the report.

Step 10: Done. Thank You