The visual XLReport Query builder allows to create SQL queries without SQL or code knowledge.
You can create queries from your database objects like tables, views and stored procedures and also from existing XLReport queries.
You can even combine database objects and XLReport queries.
Create a new Query Object
- Click >Query>New on the menu bar.
The Visual Query Builder will open.
Edit a Query Objet
- Select the Query Object in the Project Explorer , select Edit XLReport Query.
- Click >Query>Edit on the menu bar.
The Visual Query Builder will open.
Save Query
- Inside the Visual Query Builder click >Query Object>Save to save the Query.
Save Query As
- To save the Query as a new one click As>Query Object>Save to save the Query.
Delete a Query Object
- Select the Query Object in the Project Explorer , select Delete XLReport Query.