Creating Queries

Jaspersoft Studio provides tools to help you define report fields and create a proper query (if a query is needed to fetch the report data). You find these tools in the Dataset and Query dialog.

It also provides a drag-and-drop query builder for easily creating SQL queries. This allows users who are not familiar with SQL to join tables and produce complex data filters and where conditions quickly. 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