Working with Report Builder 3.0 - Learning SQL Server Reporting Services 2012 - page 254

11. For the query, you could enter an SQL SELECT statement shown when
Query type is Text .
SELECT Categories.CategoryName, Categories.Description,
Products.ProductName, Products.ProductID, Products.CategoryID,
Orders.OrderID, Orders.OrderDate,
Orders.RequiredDate, Orders.ShippedDate,
[Order Details].UnitPrice, [Order Details].ProductID AS Expr1,
[Order Details].Quantity
FROM Products INNER JOIN
[Order Details] ON Products.ProductID =
[Order Details].ProductID INNER JOIN
Orders ON [Order Details].OrderID =
Orders.OrderID INNER JOIN
Categories ON Products.CategoryID =
Categories.CategoryID
Alternatively, you could create the query by using the following tables in
the Query Designer when you click on the Query Designer... button: Order ,
Order_Details , Products , and Categories . Here the SQL statement will
be used.
12. Type in the SQL statement (copy and paste), as shown in the following
screenshot: