---
title: "Text-based Query Designer User Interface | Microsoft Docs"
ms.custom: ""
ms.date: "03/08/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: "reporting-services-native"
ms.topic: conceptual
f1_keywords:
- "10010"
- "sql12.rtp.rptdesigner.dataview.genericquerydesigner.f1"
helpviewer_keywords:
- "text-based query designer [Reporting Services]"
- "query designers [Reporting Services], text-based"
ms.assetid: 44b7c664-03aa-494e-a484-052b318e810c
author: maggiesMSFT
ms.author: maggies
manager: kfile
---
# Text-based Query Designer User Interface
Use the text-based query designer to specify a query using the query language supported by the data source, run the query, and view the results at design time. You can specify multiple [!INCLUDE[tsql](../includes/tsql-md.md)] statements, query or command syntax for custom data processing extensions, and queries that are specified as expressions. Because the text-based query designer does not preprocess the query and can accommodate any kind of query syntax, this is the default query designer tool for many data source types.
The text-based query designer displays a toolbar and the following two panes:
- **Query** Shows the query text, table name, or stored procedure name.
- **Result** Shows the results of running the query at design time.
## Text-based Query Designer Toolbar
The text-based query designer provides a single toolbar for all the command types. The following table lists each button on the toolbar and its function.
|Button|Description|
|------------|-----------------|
|**Edit As Text**|Toggle between the text-based query designer and the graphical query designer. Not all data source types support graphical query designers.|
|**Import**|Import an existing query from a file or report. Only file types sql and rdl are supported. For more information, see [Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)](report-data/report-embedded-datasets-and-shared-datasets-report-builder-and-ssrs.md).|
||Run the query and display the result set in the Result pane.|
|**Command Type**|Select **Text**, **StoredProcedure**, or **TableDirect**. If a stored procedure has parameters, the **Define Query Parameters** dialog box appears when you click **Run** on the toolbar, and you can fill in values as needed. Note that if a stored procedure returns more than one result set, only the first result set is used to populate the dataset.
Support for command type varies by data source type. For example, only OLE DB and ODBC support **TableDirect**.|
### Command Type Text
When you create a [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] dataset, Report Designer displays the graphical query designer by default. To switch to the text-based query designer, click the **Edit As Text** toggle button on the toolbar. The text-based query designer presents two panes: the Query pane and the Result pane. The following figure labels each pane.
The following table describes the function of each pane.
|Pane|Function|
|----------|--------------|
|Query|Displays the [!INCLUDE[tsql](../includes/tsql-md.md)] query text. Use this pane to write or edit a [!INCLUDE[tsql](../includes/tsql-md.md)] query.|
|Result|Displays the results of the query. To run the query, right-click in any pane and click **Run**, or click the **Run** button on the toolbar.|
#### Example
The following query returns the list of last names from the [!INCLUDE[ssSampleDBobject](../includes/sssampledbobject-md.md)] database `Contact` table.
```
SELECT LastName FROM Person.Person;
```
You can use any [!INCLUDE[tsql](../includes/tsql-md.md)] statement for Command type Text, including `EXEC` statements. The following query calls the [!INCLUDE[ssSampleDBobject](../includes/sssampledbobject-md.md)] stored procedure `uspGetEmployeeManagers` and returns the chain-of-command for the employee with identification number 1.
```
EXEC uspGetEmployeeManagers 1;
```
When you click **Run** on the toolbar, the command in the **Query** pane runs and the results are displayed in the **Result** pane.
### Command Type StoredProcedure
When you select **Command typeStoredProcedure**, the text-based query designer presents two panes: the Query pane and the Result pane. Enter the stored procedure name in the Query pane and click **Run** on the toolbar. The Define Query Parameters dialog box opens. Enter the parameter values for the stored procedure. A report parameter is created for every stored procedure parameter.
#### Example
The following query calls the [!INCLUDE[ssSampleDBobject](../includes/sssampledbobject-md.md)] stored procedure `uspGetEmployeeManagers`. You must enter a value for the employee identification number parameter when you run the query.
```
uspGetEmployeeManagers;
```
### Command Type TableDirect
When you select **Command typeTableDirect**, the text-based query designer presents two panes: the Query pane and the Result pane. When you enter a table and click the **Run** button, all the columns for that table are returned.
#### Example
The following query returns a result set for all customers in the [!INCLUDE[ssSampleDBobject](../includes/sssampledbobject-md.md)] database.
`Sales.Customer`
When you enter the table name Sales.Customer, it is the equivalent of creating the [!INCLUDE[tsql](../includes/tsql-md.md)] statement `SELECT * FROM Sales.Customer;`.
## See Also
[Query Design Tools in Report Designer SQL Server Data Tools (SSRS)](report-data/query-design-tools-ssrs.md)
[Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)](report-data/report-embedded-datasets-and-shared-datasets-report-builder-and-ssrs.md)
[SQL Server Connection Type (SSRS)](report-data/sql-server-connection-type-ssrs.md)
[OLE DB Connection Type (SSRS)](report-data/ole-db-connection-type-ssrs.md)
[ODBC Connection Type (SSRS)](report-data/odbc-connection-type-ssrs.md)
[Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)](report-data/report-embedded-datasets-and-shared-datasets-report-builder-and-ssrs.md)
[RSReportDesigner Configuration File](report-server/rsreportdesigner-configuration-file.md)