Report Information
Version: 11.0
Author: Copyright © 2004 Business Objects
Comments: Inventory cross-tab report by product/type and supplier: Includes sums on units on order and units in stock. Highlighting Expert color-codes fields where stock levels have fallen below acceptable levels.
Title: Inventory Cross-Tab Report by Product Type & Supplier
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: Product
Connection: Connection #1
Used Columns: {Product.Product ID} : Number
{Product.Product Name} : String[102]
{Product.Product Type ID} : Number
{Product.Product Class} : String[102]
{Product.Supplier ID} : Number
Table: Product Type
Connection: Connection #1
Report Alias: Product_Type
Used Columns: {Product_Type.Product Type Name} : String[102]
{Product_Type.Picture} : Unknown
Table: Purchases
Connection: Connection #1
Used Columns: {Purchases.Product ID} : Number
{Purchases.Units in Stock} : Number
{Purchases.Units on Order} : Number
{Purchases.Received} : Boolean
Table Links
Joins: Product INNER JOIN [Product Type] Product_Type ON Product.[Product Type ID] = Product_Type.[Product Type ID]
Product INNER JOIN Purchases ON Product.[Product ID] = Purchases.[Product ID]
Record Selection Formulas
Formula: {Product.Product Class} = "Accessory" and
not ({Product.Product Name} startswith "Xtreme")
Record Sorting
Sort By: Product_Type.Product Type Name -- Ascending Order Group #1
Formula Fields
Field: units on order
Formula: if {Purchases.Received}=False then {Purchases.Units on Order}
Field: Supplier
Formula: If {Product.Supplier ID} = 1 Then "Desert Supplies" else
If {Product.Supplier ID} = 2 Then "Outback Cycles" else
If {Product.Supplier ID} = 3 Then "The Bike Basement" else
If {Product.Supplier ID} = 4 Then "Crank Shafts" else
If {Product.Supplier ID} = 5 Then "ABC Supplies" else
If {Product.Supplier ID} = 6 Then "Air Cycles" Else "Polaris Cycles"
Unused Formula Fields
Field: description
Formula: if (isnull({Product.Color}) and isnull({Product.Size})) then {Product.M/F}
else
if (isnull({Product.Size}) and isnull({Product.M/F})) then {Product.Color}
else
if (isnull({Product.Color}) and isnull({Product.M/F})) then {Product.Size}
else
if isnull({Product.Color}) then {Product.Size}+" / " + {Product.M/F}
else
if isnull({Product.Size}) then {Product.Color} +" / " + {Product.M/F}
else
if isnull({Product.M/F}) then {Product.Color} + " / " +{Product.Size}
else
if (isnull({Product.Color}) and isnull({Product.Size}) and isnull({Product.M/F})) then ""
else
{Product.Color} + " / " + {Product.Size} +" / " + {Product.M/F}
Field: status
Formula: if {Purchases.Units in Stock}>{Purchases.Reorder Level} then "OK"
else
if {Purchases.Units in Stock}<={Purchases.Reorder Level} and {@units on order}=0
then "ORDER"
else
if {Purchases.Units in Stock}<={Purchases.Reorder Level} and {@units on order}>0
then "ON ORDER"
Field: DetailNoInitialize
Formula: whileprintingrecords;
numbervar DetailNo:=0
Field: DetailNo
Formula: whileprintingrecords;
numbervar DetailNo:=DetailNo + 1
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: Cross-Tab by Product Type & Supplier
Text Field: Text2
Text: Inventory Report
Pictures
Picture: RO_Xtreme_Logo
Size: 279x111
Hyperlink: http://www.businessobjects.com
Lines
Line: Line1
Ends in Section: Section1
Line Type: Single
Line Thickness: 30
Page Header
Section: Section a
Conditional Formulas
Condition: EnableSuppress
Formula: PageNumber=1
Section: Section b
Text Fields
Text Field: Text3
Text: Potential Stock Out
Tool Tip Formula: "Use Highlighting Expert to create a simple formula that will color-code a field based on designated value(s)."
Text Field: Text4
Text: Total Units on Order
Tool Tip Formula: "Use Highlighting Expert to create a simple formula that will color-code a field based on designated value(s)."
Text Field: Text5
Text: Suppliers
Boxes
Box: Box1
Ends in Section: Section3
Size: 20x20
Line Type: Single
Line Thickness: 20
Box: Box2
Ends in Section: Section3
Size: 20x21
Line Type: Single
Line Thickness: 20
Lines
Line: Line2
Ends in Section: Section3
Line Type: Single
Line Thickness: 30
Groups
Group: Group #1
Grouped By: {Product_Type.Product Type Name}
Group Header
Section: Section a
Pictures (Blobs)
Picture (Blob): Field6
Data Source: {Product_Type.Picture}
Size: 204x120
Cross-Tabs
Cross-Tab: CrossTab1
Page Footer
Section: Section a
Fields
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
Text Fields
Text Field: Text7
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@businessobjects.com
Text Field: Text6
Text: Business Objects Technical Support Site
Hyperlink: http://support.businessobjects.com
Text Field: Text8
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: Line3
Ends in Section: Section8
Line Type: Single
Line Thickness: 30