**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\Product Catalog.rdl **************************************************************************** Report Information Description Report Title: Product Catalog Report Author: Copyright © 2004 Business Objects Report Comments: Product catalog, grouped by Product Class, Product Type and Product Name with Product Type picture and description. Drill down on Product Name for item numbers, sizes, etc. Converted By: Crystal Migration Services, support@crystalmigrater.com Data Sources DataSource1 Name DataSource1 Connection String DSN=Xtreme Sample Database 11.5; Data Provider ODBC Datasets DataSet1 Name DataSet1 Query Data Source DataSource1 CommandText SELECT Product.[Product Class], Product.[Product Name], Product.[M/F], Product.Size, Product.Color, Product.[Product ID], Product_Type.[Product Type Name], Product.[Price (SRP)], Product_Type.Description, Product_Type.Picture FROM Product Product INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID]=Product_Type.[Product Type ID] ORDER BY Product.[Product Class], Product_Type.[Product Type Name], Product.[Product Name], Product.[Product ID] Parameters Fields Product_Class Name Product_Class Source [Product Class] Data Type String Product_Name Name Product_Name Source [Product Name] Data Type String M_F Name M_F Source M/F Data Type String Size Name Size Source Size Data Type String Color Name Color Source Color Data Type String Product_ID Name Product_ID Source [Product ID] Data Type Int32 Product_Type_Name Name Product_Type_Name Source [Product Type Name] Data Type String Description Name Description Source Description Data Type Byte[] Price_SRP_ Name Price_SRP_ Source [Price (SRP)] Data Type Decimal Picture Name Picture Source Picture Data Type Byte[] Embedded Images Picture_A2D8E55F449BDCA6DA69F73BB67F1020 Name Picture_A2D8E55F449BDCA6DA69F73BB67F1020 Type jpeg Picture_A71C16DB5FC6FA97CA22693727225E5E Name Picture_A71C16DB5FC6FA97CA22693727225E5E Type jpeg Body Report Items Text1 Name Text1 Type Text Box Content Product Catalog Field1 Name Field1 Type Text Box Content =Format(Globals.ExecutionTime, "dd/MM/yyyy") Field2 Name Field2 Type Text Box Content =Format(Globals.ExecutionTime, "h:m:s tt") Picture4 Name Picture4 Type Image Source Type Embedded Image Name Embedded Image Name Picture_A71C16DB5FC6FA97CA22693727225E5E RectArea3 Name RectArea3 Type Rectangle Field3_class Name Field3_class Type Text Box Content =IIF ((Fields!Product_Class.Value = "Accessory"), ("Accessories"), IIF (( Fields!Product_Class.Value = "Bicycle" ), ("Bicycles"), "")) RectArea4 Name RectArea4 Type Rectangle Product_Type_Name Name Product_Type_Name Type Text Box Content =Fields!Product_Type_Name.Value Description Name Description Type Text Box Content =Fields!Description.Value Picture1 Name Picture1 Type Image Source Type Database Image Expression Database Image Expression =Fields!Picture.Value Image Type jpeg Text2 Name Text2 Type Text Box Content Product Name Text3 Name Text3 Type Text Box Content Unit Price RectArea5 Name RectArea5 Type Rectangle Product_Name Name Product_Name Type Text Box Content =Fields!Product_Name.Value Text4 Name Text4 Type Text Box Content =Fields!Price_SRP_.Value RectSection7 Name RectSection7 Type Rectangle Text5 Name Text5 Type Text Box Content Item No. Text6 Name Text6 Type Text Box Content Color Text7 Name Text7 Type Text Box Content Size Text8 Name Text8 Type Text Box Content M/F RectSection8 Name RectSection8 Type Rectangle M_F Name M_F Type Text Box Content =Fields!M_F.Value Size Name Size Type Text Box Content =Fields!Size.Value Color Name Color Type Text Box Content =Fields!Color.Value Product_ID Name Product_ID Type Text Box Content =Fields!Product_ID.Value RectArea7 Name RectArea7 Type Rectangle RectArea8 Name RectArea8 Type Rectangle RectArea9 Name RectArea9 Type Rectangle Data Regions Tablix1 Name Tablix1 Type Table Row Member 1 Group1 Name Group1 Expressions =Fields!Product_Class.Value Sort Expressions =Fields!Product_Class.Value Row Member 1 Row Member 2 Group2 Name Group2 Expressions =Fields!Product_Type_Name.Value Sort Expressions =Fields!Product_Type_Name.Value Row Member 2 Row Member 3 Group3 Name Group3 Expressions =Fields!Product_Name.Value Sort Expressions =Fields!Product_Name.Value Row Member 3 Row Member 4 Details Name Details Sort Expressions =Fields!Product_ID.Value Row Member 4 Row Member 5 Row Member 7 Row Member 9 Row Member 11 Source Dataset DataSet1 Page Footer Report Items Field12 Name Field12 Type Text Box Content =Globals!PageNumber Picture2 Name Picture2 Type Image Source Type Embedded Image Name Embedded Image Name Picture_A2D8E55F449BDCA6DA69F73BB67F1020 Actions Go to URL http://www.businessobjects.com Text9 Name Text9 Type Text Box Content Business Objects Technical Support Site Actions Go to URL http://support.businessobjects.com Text10 Name Text10 Type Text Box Content Copyright 2004 Business Objects Software Limited. All rights reserved. Business Objects, the Business Objects logo, Crystal Reports, Crystal Enterprise, Crystal Analysis, WebIntelligence, RapidMarts, and BusinessQuery are trademarks or registered trademarks of Business Objects and its affiliates in the United States and/or other countries. Other trademarks are the property of their respective owners. Business Objects owns the following U.S. patents, which may cover products that are offered and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and 6,289,352. Text11 Name Text11 Type Text Box Content Feedback on Samples by E-mail Actions Go to URL mailto:crfeedback@businessobjects.com