Report Subquery
1. Click on subquery icon to create subquery
2. Click on “+” icon to create
3. Enter/select the values in following fields
a) Subquery Name
b) Report Name
c) Subquery Column
4. Click on add Row to create Subquery Conditions and in the Subquery Conditions window, create conditions by utilizing specific functions and operators.
5. Click on filter criteria. Select filter type to normal and Click the 
icon to modify the entries in the Item and Value(s) column and to view created subquery. Drag and drop Sub Queries.
6. Select the created Subquery and The SQL query for the created subquery will be as follows
