**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\General Business\Product Catalog.rpt **************************************************************************** Report Information Version: 11.0 Author: Copyright © 2004 Business Objects 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. Title: Product Catalog Printer: No Printer Main Body Data Sources Source: Connection #1 Database DLL: crdb_odbc.dll Database Type: ODBC (RDO) Server: Xtreme Sample Database 11.5 Properties: QE_LogonProperties DSN: Xtreme Sample Database 11.5 UseDSNProperties: False QE_SQLDB: True SSO Enabled: False Report Parameters Parameter: Directory Data Type: String Description: Enter the BusinessObjects directory location: List Type: Static List Values: c:\Program Files\ d:\Program Files\ Default Values: c:\Program Files\ Initial Values: c:\Program Files\ Tables Table: Product Connection: Connection #1 Used Columns: {Product.Product ID} : Number {Product.Product Name} : String[102] {Product.Color} : String[42] {Product.Size} : String[22] {Product.M/F} : String[22] {Product.Price (SRP)} : Number {Product.Product Type ID} : Number {Product.Product Class} : String[102] Table: Product Type Connection: Connection #1 Report Alias: Product_Type Used Columns: {Product_Type.Product Type Name} : String[102] {Product_Type.Description} : Unknown {Product_Type.Graphic Image Location} : String[502] Table Links Joins: Product INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID] Record Sorting Sort By: Product.Product Class -- Ascending Order Group #1 Product_Type.Product Type Name -- Ascending Order Group #2 Product.Product Name -- Ascending Order Group #3 Product.Product ID -- Ascending Order Formula Fields Field: class Formula: if {Product.Product Class}="Accessory" then "Accessories" else if {Product.Product Class}="Bicycle" then "Bicycles" Report Header Section: Section a Fields Field: Field1 Data Source: PrintDate Data Type: Date Format: Date and Time Order: Date Time Date Type: System Default Date Format: YYYY-MM-DD hh:mm:ss AM Field: Field2 Data Source: PrintTime Data Type: Time Format: Date and Time Order: Date Time Date Type: System Default Time Format: MM/DD/YY h:mm:ss AM Text Fields Text Field: Text1 Text: Product Catalog Pictures Picture: RO_Xtreme_Logo Size: 279x111 Hyperlink: http://www.businessobjects.com Lines Line: Line1 Ends in Section: Section1 Line Type: Single Line Thickness: 0 Line: Line2 Ends in Section: Section1 Line Type: Single Line Thickness: 30 Page Header Section: Section a Conditional Formulas Condition: EnableSuppress Formula: PageNumber=1 Groups Group: Group #1 Grouped By: {Product.Product Class} Group Header Section: Section a Fields Field: Field3 Data Source: {@class} Data Type: String Group: Group #2 Grouped By: {Product_Type.Product Type Name} Group Header Section: Section a Fields Field: Field4 Data Source: {Product_Type.Product Type Name} Data Type: String Field: Field5 Data Source: {Product_Type.Description} Data Type: Unknown Pictures Picture: Picture1 Picture Location: {?Directory} + {Product_Type.Graphic Image Location} Size: 196x131 Section: Section b Text Fields Text Field: Text2 Text: Product Name Text Field: Text3 Text: Unit Price Group: Group #3 Grouped By: {Product.Product Name} Group Header Section: Section a Fields Field: Field7 Data Source: {Product.Product Name} Data Type: String Text Fields Text Field: Text4 Text: {Product.Price (SRP)} Lines Line: Line3 Ends in Section: Section6 Line Type: Single Line Thickness: 20 Detail Section: Section a Text Fields Text Field: Text5 Text: Item No. Text Field: Text6 Text: Color Text Field: Text7 Text: Size Text Field: Text8 Text: M/F Section: Section b Fields Field: Field8 Data Source: {Product.M/F} Data Type: String Field: Field9 Data Source: {Product.Size} Data Type: String Field: Field10 Data Source: {Product.Color} Data Type: String Field: Field11 Data Source: {Product.Product ID} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5555555 Lines Line: Line4 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Page Footer Section: Section a Fields Field: Field12 Data Source: PageNumber Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5,555,555 Text Fields Text Field: Text9 Text: Business Objects Technical Support Site Hyperlink: http://support.businessobjects.com Text Field: Text10 Text: 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. Text Field: Text11 Text: Feedback on Samples by E-mail Hyperlink: mailto:crfeedback@businessobjects.com Pictures Picture: Picture2 Size: 150x40 Hyperlink: http://www.businessobjects.com Lines Line: Line5 Ends in Section: Section13 Line Type: Single Line Thickness: 30