Report Solution Patterns and Recipes - Professional SQL Server 2005 Reporting Services - page 318

Production.Product.Name, Production.Product.ProductNumber,
Production.Product.StandardCost, Production.Product.ListPrice,
Production.Product.ProductSubcategoryID
FROM Production.Product INNER JOIN
Production.ProductSubcategory ON
Production.Product.ProductSubcategoryID =
Production.ProductSubcategory.ProductSubcategoryID
AND
Production.Product.ProductSubcategoryID =
Production.ProductSubcategory.ProductSubcategoryID
WHERE (Production.Product.ProductSubcategoryID = @ProductSubCategoryID)
ORDER BY Production.ProductSubcategory.Name, Production.Product.Name
In this example, a text box is used to set these parameters and perform the update. The sample report is
shown in design view in Figure 7-61.
Figure 7-61
Figure 7-62 shows the Report Parameters dialog with two parameters matching those in the stored pro-
cedure. The SubCategoryID parameter is based on a list supplied by the ProductSubCategory table. In
the example, I've predefined a list of price increase percentage values, shown in Figure 7-63. Note that
the default value is zero, which allows the procedure to execute without modifying any product records.