![report builder parameter report builder parameter](https://docs.microsoft.com/en-us/sql/reporting-services/report-design/media/ssrb-paramdatasetprops.png)
You will add query parameters later in this tutorial.Ģ. This query does not contain query parameters. Later in this tutorial, you will look up the name of the store that corresponds to the store identifier from a separate dataset. The result set consists of 11 rows of data that show the quantity of items sold for each subcategory for four stores, in the following columns: StoreID, Subcategory, Quantity.The store name is not part of the result set. On the query designer toolbar, click Run ( !) to see the data. The subcategories are digital cameras, digital single lens reflex (SLR) cameras, camcorders, and accessories. This query combines the results of several Transact-SQL SELECT statements inside a common table expression to specify values that are based on simplified sales data for cameras from the Contoso sample database. UNION SELECT 307 AS StoreID, 'Digital SLR Cameras' AS Subcategory, 1772 AS Quantity) UNION SELECT 307 AS StoreID, 'Camcorders' AS Subcategory, 1631 AS Quantity UNION SELECT 307 AS StoreID, 'Accessories' AS Subcategory, 1755 AS Quantity UNION SELECT 306 AS StoreID, 'Accessories' AS Subcategory, 1534 AS Quantity UNION SELECT 306 AS StoreID, 'Digital Cameras' AS Subcategory, 1553 AS Quantity UNION SELECT 306 AS StoreID, 'Camcorders' AS Subcategory, 1561 AS Quantity UNION SELECT 306 AS StoreID, 'Digital SLR Cameras' AS Subcategory, 1579 AS Quantity UNION SELECT 199 AS StoreID, 'Digital Cameras' AS Subcategory, 1849 AS Quantity UNION SELECT 200 AS StoreID, 'Accessories' AS Subcategory, 1895 AS Quantity UNION SELECT 200 AS StoreID, 'Camcorders' AS Subcategory, 1954 AS Quantity SELECT 200 AS StoreID, 'Digital SLR Cameras' AS Subcategory, 2002 AS Quantity Paste the following query into the empty pane at the top: WITH CTE (StoreID, Subcategory, Quantity) On the Design a query page, click Edit as Text. Select any data source that is type SQL Server. On the Choose a connection to a data source page, select a data source from the list or browse to the report server to select one. On the Choose a dataset page, click Create a dataset > Next.
![report builder parameter report builder parameter](https://docs.microsoft.com/en-us/power-bi/paginated-reports/media/paginated-reports-parameters/power-bi-paginated-parameters-report-builder.png)
In the right pane, click Table or Matrix Wizard. In the left pane, make sure New Report is selected. If you don't see the New Report or Dataset dialog box, on the File menu > New. The New Report or Dataset dialog box opens. Start Report Builder either from your computer, the Reporting Services web portal, or SharePoint integrated mode. In a business environment, a query would not contain the data. In this tutorial, the query contains the data values, so that it does not need an external data source.