Query Builder Panes
The Object path shows the bread-crumb structure of the Report Object location.
Shows the Data Connection of the Query Object.
The Diagram Pane allows to visually select tables / views and its fields to be included in the Query.
The Grid Pane allows to select fields, assign expressions, sort orders, aggregate functions and apply criteria and parameters.
The SQL Pane allows to edit the SQL syntax manually.
XLReport allows full synchronization between Diagram, Grid and SQL Panes.
Once you change any setting in any pane all other panes will synchronize automatically.
Important! When working with complex queries and sub-queries, synchronization between panes might slow down your work . Therefore it is recommended to turn the SQL pane off.
- To turn the SQL pane off, unselect View and SQL Pane on the menu bar.
Tip! You can also write an SQL syntax manually or paste an existing SQL code and the Diagram and the Grid pane will synchronize.