Query Builder (Report Wizard)

Use the Query Builder to specify a query that retrieves a result set to use in a report. You can choose between two query builders:

Generic query builder (default) provides a very simple workspace for specifying a query and viewing the results. You can specify multiple Transact-SQL statements, query or command syntax for custom data processing extensions, and queries that are specified as expressions. Because the generic query builder does not preprocess the query and can accommodate any kind of query syntax, it is the default query builder tool for Report Designer.
Graphical query builder provides a richer visual experience. It is used in Visual Studio and in other parts of SQL Server 2005. You can use the graphical query builder if you are not creating expressions or multi-part SQL statements.
To switch to the graphical query builder, toggle the generic query builder icon in the top left corner of the window.

Generic Query Builder Options

! (Run)
Executes the query and returns a result set if the query is valid. Note that you cannot execute the query if it is an expression. To verify an expression-based query, you must preview the report.

Command type
Specifies text, stored procedure or table direct. Availability of a command type depends on the data processing extension you specified.