Object type: Reporting Services report

Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content
No	No	No	No

Data Source Activity 

Accesses	Description
Production.Product	Products sold or used in the manfacturing of sold products.
Production.ProductCategory	High-level product categorization.
Production.ProductDescription	Product descriptions in several languages.
Production.ProductModel	Product model classification.
Production.ProductModelProductDescriptionCulture	Cross-reference table mapping product descriptions and the language the description is written in.
Production.ProductPhoto	Product images.
Production.ProductProductPhoto	Cross-reference table mapping products and product photos.
Production.ProductSubcategory	Product subcategories. See ProductCategory table.

Report Queries 

ProductCatalog Used In:  Name  Report type  Description  ProductTable  Table    Parameters  Variable  Description  Language    Output Recordset  Column  Description  ProdSubCat    ProdModel    ProdCat    Description    LargePhoto    ProdName    ProductNumber    Color    Size    Weight    StandardCost    Style    Class    ListPrice    Data source  Description  Production.Product  Products sold or used in the manfacturing of sold products.  Production.ProductCategory  High-level product categorization.  Production.ProductDescription  Product descriptions in several languages.  Production.ProductModel  Product model classification.  Production.ProductModelProductDescriptionCulture  Cross-reference table mapping product descriptions and the language the description is written in.  Production.ProductPhoto  Product images.  Production.ProductProductPhoto  Cross-reference table mapping products and product photos.  Production.ProductSubcategory  Product subcategories. See ProductCategory table.

Applies to

Reporting Services reports | Command Text

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation