UNION SELECT CAST('' AS date) as SalesDate, 'Fernando Ross' as FullName,'South' as Territory, 'Accessories' as Subcategory,'Tripod' as Product, CAST(1125.00 AS money) AS Sales, 15 as Quantity UNION SELECT CAST('' AS date) as SalesDate, 'Warren Pal' as FullName,'North' as Territory, 'Accessories' as Subcategory,'Tripod' as Product, CAST(1800.00 AS money) AS Sales, 24 as Quantity UNION SELECT CAST('' AS date) as SalesDate, 'Lauren Johnson' as FullName,'Central' as Territory, 'Accessories' as Subcategory,'Tripod' as Product, CAST(1350.00 AS money) AS Sales, 18 as Quantity UNION SELECT CAST('' AS date) as SalesDate, 'Fernando Ross' as FullName,'South' as Territory, 'Accessories' as Subcategory,'Carrying Case' as Product, CAST(9248.15 AS money) As Sales, 37 as Quantity UNION SELECT CAST('' AS date) as SalesDate, 'Warren Pal' as FullName,'North' as Territory, 'Accessories' as Subcategory, 'Carrying Case' as Product, CAST(13747.25 AS money) AS Sales, 55 as Quantity Verify that the Text query type is selected, and then click Query Designer.Ĭopy and paste the following query into the query pane: SELECT CAST('' AS date) as SalesDate, 'Lauren Johnson' as FullName,'Central' as Territory, 'Accessories' as Subcategory,'Carrying Case' as Product, CAST(16996.60 AS money) AS Sales, 68 as Quantity In the Report Data pane, click New > Dataset.Ĭlick Use a dataset embedded in my report, and verify that the data source is ListDataSource. The default database on the specified server is just used to parse the query.Ĭlick Credentials, and enter the credentials needed to connect to the instance of the SQL Server Database Engine. Because the data for this report is not extracted from a SQL Server database, you need not include the name of a database. , for example Report001, specifies a computer on which an instance of the SQL Server Database Engine is installed. Verify that the connection type is Microsoft SQL Server, and then in the Connection string box type: Data Source = In the Report Data pane, click New > Data Source.Ĭlick Use a connection embedded in my report. 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.