| title | Design the Query | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | reporting-services-native | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | 2dad800f-10a1-453c-8761-2935b9826d84 | |
| author | maggiesMSFT | |
| ms.author | maggies | |
| manager | kfile |
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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion], you can enter [!INCLUDEtsql] statements or stored procedure names. If the data source type is [!INCLUDEssNoVersion] [!INCLUDEssASnoversion], the Query pane is disabled and you cannot enter a query directly. You can specify the query by using Query Builder.
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.
For the data source type Microsoft SQL Server, the following query retrieves a list of last names from the [!INCLUDEssSampleDBobject] database Person table.
SELECT LastName FROM Person.Person;
For the data source type Microsoft SQL Server, the following query runs the [!INCLUDEssSampleDBobject] stored procedure uspGetEmployeeManagers for the employee with identification number 1:
EXEC uspgetEmployeeManagers '1';
Report Wizard Help
Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
Add Data to a Report (Report Builder and SSRS)