How to Write SQL Query in Parameter and Use it in Main and Sub Datasets

Prerequisites: Jasper Server 6.4.2

Database: Foodmart

In this blog, we will learn how we can write an SQL query in parameter and use in Main Dataset or Sub Datasets.

1. Created a sample query which as follows and created a report in jasper server

select full_name,position_title,hire_date,salary from employee where “position_title” =’President’

union

select full_name,position_title,hire_date,salary from employee where “position_title” =’VP Country Manager’

Output as:

2. Now we will write the below query in parameter and use in the main dataset

select full_name,position_title,hire_date,salary from employee where “position_title” =’VP Country Manager’

The above query we need to write in parameter default expression

3. Use this parameter in the main dataset

4. Deploy the Report and check the output

5. Output

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download

In case if you have any queries please get us at support@helicaltech.com

Thanks,

Satya Gopi

Helical IT Solutions Pvt Ltd