Creating Queries

Jaspersoft Studio provides tools to help you define report fields and create a proper query if a query language is used to acquire the data for the report. These tools are presented in the Dataset and Query dialog.

It also provides an easy way to build SQL queries by using a drag-and-drop query builder. This allows users who don’t know SQL or just are not sure about the syntax to quickly join tables and produce complex data filters and where conditions. SQL Builder also provides a way for skilled users to explore the database and list the metadata such as schemas and available tables.

This chapter contains the following sections:

Using the Dataset and Query Dialog
Working with the Query Builder