Creating Queries

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email with questions or issues requiring TIBCO review or response.

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