Defining a Query Report
- On the Queries interface, click on Query Report, this opens query reports interface.
- If there is no report defined before you can quickly create new one, click on
- and give name and display name for the report.
- Then Click on Report Design Tool, the following screen is the view of report design tool:
o prepare a quick way, select Design in Report Wizard:
Then select a template and click on Next:
You see that the report wizard has two panels: the left panel lists the query result fields. From these areas, the ones required to take part in the report are selected (in selected data fields panel) then click on next or you can finish here too
Then you create groups from available data fields. From available fields to groups, click on + button to get multiple for the same group, click on up down arrows to order the groups , e.g. World Happiest Country Field will be at the top of the query result screen etc.
At the next stage, you select data fields and functions for data summary operation:
Then enter a title for the report and click on Finish.