Web Listing 1: SQL statement used to return the rowset for the report

SELECT     Name, ProductNumber, StandardCost, ListPrice, ListPrice-StandardCost AS Profit,

DiscontinuedDate, ProductID, Style, Class
FROM        Production.Product
WHERE     (Style = @StyleWanted)