A query is a set of instructions that specifies which data to use in a report. SQR Production Reporting Studio comes with a query builder. The Query Builder contains several pages that collect information and step you through process of building a query. SQR Production Reporting Studio launches the Query Builder when you perform any of the following actions:
Select File, then New, specify the desired type of report, and connect to the database.
Display an existing report in the Layout window and click the Edit Query button on the Standard Toolbar, or select Report, then Edit Query.
Display an existing report in the Layout window, click the Insert Fields button on the Standard Toolbar, choose New, and select a query type.
Using the Query Builder, you can define the following information for your query:
Expressions that will compute a value based on other values in the database
Custom From clauses to further limit the information printed
The default layout to use in your report
Tabular reports can have more than one query. You can create reports with multiple queries (see Creating Reports with Multiple Queries), and you can create reports with nested subqueries (see Creating Reports with Nested Subqueries).