Design the Query

 

Applies To: SQL Server 2016

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 AdventureWorks2014 database Person table.

SELECT LastName FROM Person.Person;  

For the data source type Microsoft SQL Server, the following query runs the AdventureWorks2014 stored procedure uspGetEmployeeManagers for the employee with identification number 1:

EXEC uspgetEmployeeManagers '1';  

See Also

Report Wizard Help
Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
Report Datasets (SSRS)