• Article

Design the Query

Use this page of the Report Wizard to create a query by typing the query manually, by using Query Builder to interactively build a query, or by importing a query from another report.

The data source type you chose on the Select the Data Source page, a previous page in the Report Wizard, determines the query you can enter on this page. For example, if the data source type is Microsoft SQL Server, you can enter Transact-SQL statements or stored procedure names. If the data source type is SQL Server Analysis Services, the Query pane is disabled and you cannot enter a query directly. You can specify the query by using Query Builder.

Options

  • Query string
    Type a query that retrieves the data you want to use in your report.

  • Query Builder
    Click Query Builder to open a query designer for the data source, or to import a query from another report.

For more information about query designers, see Reporting Services Query Designers.

Example

For the data source type Microsoft SQL Server, the following query retrieves a list of last names from the AdventureWorks database Contact table.

SELECT LastName FROM Person.Contact

For the data source type Microsoft SQL Server, the following query runs the AdventureWorks stored procedure uspgetEmployeeManagers for the employee with identification number 1.

EXEC uspgetEmployeeManagers '1'