Binding the Detail Query to the Master Query

To display the results of a master query and a detail query in one report, you must bind the queries (see Binding Queries).

To bind queries, use the mouse to drag query fields from one table to another. You can also click Auto Bind to automatically join table columns for which both the name and the data type are the same. You must bind at least one table column in the master query to a table column in the detail query.

SQR Production Reporting Studio automatically joins columns for which both the name and the data type are the same.

When you create a detail query, it appears below the master query in the Database tab of the Report Fields dialog box and in the Queries section on the left-hand side of the Layout window.