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.
For the data source type Microsoft SQL Server, the following query retrieves a list of last names from the AdventureWorks2012 database Person table.
SELECT LastName FROM Person.Person;
For the data source type Microsoft SQL Server, the following query runs the AdventureWorks2012 stored procedure uspGetEmployeeManagers for the employee with identification number 1:
EXEC uspgetEmployeeManagers '1';