Link to query builder
Launch Report Design screen under Configure à Analytical Report à Report Design.
Click on ‘+’ icon to create a new Report.
Click the link ‘Link to Query Builder’ in the above screen, to launch the Query Builder screen,
For generation of the desired query.
Click “Get” list the table.
Select tables from grid and click “Save”.
The screen moves to the next tab “Field Selection”, where the required columns from the selected tables can be selected.
Click “save” and move to next tab Build Relationship.
This tab helps to link the tables chosen for the query, as required.
Click link “Define Relation”.
Take help on the “Base Table Field” to select a column from base table, for joining appropriately with the other participating tables.
Choose the “Join Type’ “as required.
Take help on the ‘Related Table Field’ to select a column from participating table for joining with the base table.
Click “Save” and click” back”.
Click “Filter Selection”.
This tab helps in providing filter conditions for the columns chosen in the earlier step. Choose the required columns and provide the filter values accordingly.
Click on the ‘Next’ tab the focus passes to the View Query tab, where generated query gets displayed.
Click “Save “and design new report using this query.