Advanced Report Design - Professional SQL Server 2005 Reporting Services - page 193

Type the following SQL expression into the third pane of the Query Builder or use the techniques illus-
trated in Figure 6-10 to design the query using the Graphical Query Design tools:
SELECT
Production.Product.ProductID
, Production.ProductCategory.Name AS CategoryName
, Production.ProductSubcategory.Name AS SubCategoryName
, Production.Product.Name AS ProductName
FROM
Production.Product
INNER JOIN Production.ProductSubcategory
ON Production.Product.ProductSubcategoryID =
Production.ProductSubcategory.ProductSubcategoryID
INNER JOIN Production.ProductCategory
ON Production.ProductSubcategory.ProductCategoryID =
Production.ProductCategory.ProductCategoryID
ORDER BY
Production.ProductCategory.Name
, Production.ProductSubcategory.Name
, Production.Product.Name
Figure 6-12 shows this query in the Graphical Query Designer.
Figure 6-12
Switch to the Layout tab and drag a Table item from the Toolbox to the report designer. Click on the
table, and then click the gray table selector handle on the top left to select the entire table.