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