Report Information
Version: 11.0
Author: Copyright © 2004 Business Objects
Comments: Order packing list grouped on Customer Name and Order ID.
Title: Order Packing List
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
Tables
Table: Customer
Connection: Connection #1
Used Columns: {Customer.Customer ID} : Number
{Customer.Customer Name} : String[82]
{Customer.Address1} : String[122]
{Customer.Address2} : String[42]
{Customer.City} : String[42]
{Customer.Region} : String[62]
{Customer.Country} : String[62]
{Customer.Postal Code} : String[22]
Table: Employee
Connection: Connection #1
Used Columns: {Employee.Employee ID} : Number
{Employee.Last Name} : String[42]
{Employee.First Name} : String[22]
Table: Orders
Connection: Connection #1
Used Columns: {Orders.Order ID} : Number
{Orders.Customer ID} : Number
{Orders.Employee ID} : Number
{Orders.Ship Via} : String[42]
{Orders.Shipped} : Boolean
Table: Orders Detail
Connection: Connection #1
Report Alias: Orders_Detail
Used Columns: {Orders_Detail.Product ID} : Number
{Orders_Detail.Quantity} : Number
Table: Product
Connection: Connection #1
Used Columns: {Product.Product ID} : Number
{Product.Product Name} : String[102]
{Product.Color} : String[42]
{Product.Size} : String[22]
Table Links
Joins: Customer INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
Orders INNER JOIN Employee ON Orders.[Employee ID] = Employee.[Employee ID]
Orders INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID]
[Orders Detail] Orders_Detail INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID]
Record Selection Formulas
Formula: not {Orders.Shipped}
//{Orders.Order Date} in [Date (1998, 04, 12), Date (1998, 04, 30)]
Record Sorting
Sort By: Customer.Customer Name -- Ascending Order Group #1
Orders.Order ID -- Ascending Order Group #2
Formula Fields
Field: size/color
Formula: {Product.Size}+" inch / "+{Product.Color}
Field: address1&2
Formula: if IsNull({Customer.Address1}) then {Customer.Address2}
else
if IsNull({Customer.Address2}) then {Customer.Address1}
else
{Customer.Address2} + ", " + {Customer.Address1}
Field: ciy/region
Formula: if IsNull({Customer.City}) then {Customer.Region}
else
if IsNull({Customer.Region}) then {Customer.City}
else
{Customer.City} + ", " + {Customer.Region}
Field: salesperson
Formula: {Employee.First Name}+" "+{Employee.Last Name}
Field: Xtreme phone/fax
Formula: "Phone: (604) 681-3435 Fax: (604) 681-2934"
Field: Xtreme Address
Formula: "2001 Meridian Way, Vancouver, BC, Canada V6G 3G6"
Unused Formula Fields
Field: amount
Formula: {Orders_Detail.Unit Price}*{Orders_Detail.Quantity}
Field: ProdNameG
Formula: whileprintingrecords;
if Remainder (RecordNumber,2 )<>0 then
"grey"
else""
Report Header
Section: Section a
Text Fields
Text Field: Text1
Text: `
Boxes
Box: Box1
Ends in Section: Section1
Size: 0x0
Line Type: Single
Line Thickness: 0
Page Header
Section: Section a
Headings
Heading: Text26
Text: Quantity
Groups
Group: Group #1
Grouped By: {Customer.Customer Name}
Group: Group #2
Grouped By: {Orders.Order ID}
Group Header
Section: Section a
Fields
Field: Field1
Data Source: {Orders.Order ID}
Data Type: Number
Format: Number
Currency Symbol: None
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: 5555555
Field: Field3
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
Field: PrintDate1
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: PrintTime1
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: Text2
Text: Order No.:
Text Field: Text4
Text: Page No.:
Text Field: Text5
Text: PLEASE OPEN AND INSPECT IMMEDIATELY
Text Field: Text6
Text: Order Packing List
Pictures
Picture: RO_Xtreme_Logo
Size: 279x111
Hyperlink: http://www.businessobjects.com
Boxes
Box: Box2
Ends in Section: Section4
Size: 0x0
Line Type: Single
Line Thickness: 0
Box: Box4
Ends in Section: Section4
Size: 400x19
Line Type: Single
Line Thickness: 20
Lines
Line: Line8
Ends in Section: Section4
Line Type: Single
Line Thickness: 30
Section: Section b
Fields
Field: Field4
Data Source: {Orders.Order ID}
Data Type: Number
Format: Number
Currency Symbol: None
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: 5555555
Field: Field5
Data Source: {@salesperson}
Data Type: String
Field: Field6
Data Source: {Orders.Ship Via}
Data Type: String
Text Fields
Text Field: Text7
Text: Ship to:
Text Field: Text8
Text: Ship From:
Text Field: Text9
Text: {Customer.Customer Name}
{@address1&2}
{@ciy/region}
{Customer.Country}
{Customer.Postal Code}
Text Field: Text10
Text: Xtreme Mountain Bikes, Inc.
2001 Meridian Way
Vancouver, BC
Canada
V6G 3G6
Text Field: Text11
Text: Shipped Via:
Text Field: Text12
Text: Sales Person:
Text Field: Text13
Text: P.O. Number:
Lines
Line: Line1
Ends in Section: Section5
Line Type: Single
Line Thickness: 10
Line: Line2
Ends in Section: Section5
Line Type: Single
Line Thickness: 10
Line: Line3
Ends in Section: Section5
Line Type: Single
Line Thickness: 20
Section: Section c
Text Fields
Text Field: Text14
Text: Description
Text Field: Text15
Text: Item No.
Text Field: Text16
Text: Unit
Text Field: Text17
Text: Qty Ordered
Text Field: Text18
Text: Qty Shipped
Lines
Line: Line4
Ends in Section: Section8
Line Type: Single
Line Thickness: 20
Detail
Section: Section a
Fields
Field: Field7
Data Source: {Orders_Detail.Product ID}
Data Type: Number
Format: Number
Currency Symbol: None
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: -5555555
Field: Field8
Data Source: {Orders_Detail.Quantity}
Data Type: Number
Format: Number
Currency Symbol: None
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: -5,555,555
Field: Field10
Data Source: {Orders_Detail.Quantity}
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: Text19
Text: EA
Text Field: Text20
Text: {Product.Product Name} {@size/color}
Page Footer
Section: Section a
Fields
Field: Field9
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: Text21
Text: {@Xtreme Address} {@Xtreme phone/fax}
Text Field: Text22
Text: Xtreme Mountain Bikes, Inc.
Text Field: Text23
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@businessobjects.com
Text Field: Text24
Text: Business Objects Technical Support Site
Hyperlink: http://support.businessobjects.com
Text Field: Text25
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.
Pictures
Picture: Picture2
Size: 150x40
Hyperlink: http://www.businessobjects.com
Lines
Line: Line5
Ends in Section: Section11
Line Type: Single
Line Thickness: 0
Line: Line6
Ends in Section: Section11
Line Type: Single
Line Thickness: 30