Partilhar via


Query Builder (Report Designer)

Use the Query Builder dialog box to define query information for the report.

Diagram Pane

Use the diagram pane to view the tables that are used by the query, manage joins between tables, and select fields. When you add tables to the query, Query Designer creates joins between tables based on the keys in the table. To add a join, drag a field from one table onto a field in another table. To manage a join, right-click the join. To add fields to the query, select the check box next to the field you want to add.

Grid Pane

Use the grid pane to manage individual fields within the query. The options available in the grid pane are Alias, Table, Output, Sort Type, Sort Order, Criteria, and Group By.

SQL Pane

Use the SQL pane to view and modify the SQL syntax directly. Editing SQL code in the SQL pane affects both the diagram and grid panes.

Result Pane

Use the result pane to view the results of the query. To run a query, either right-click anywhere in the designer and then click Run, or click Run in the toolbar.

See Also

Reference

Report Designer F1 Help

Other Resources

Defining Report Datasets

Help and Information

Getting SQL Server 2005 Assistance