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