Report Information
Version: 10.2
Author: © 2003 Crystal Decisions Inc.
Title: Charting
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 Name} : String[82]
{Customer.Last Year's Sales} : Number
{Customer.Region} : String[62]
{Customer.Country} : String[62]
{Customer.Postal Code} : String[22]
Record Selection Formulas
Formula: {Customer.Country} in ["Thailand", "Singapore", "Philippines", "Pakistan", "New Zealand", "Nepal", "Mongolia", "Malaysia", "Japan", "Indonesia", "India", "China", "Bangladesh", "Australia"]
Record Sorting
Sort By: Customer.Country -- Ascending Order Group #1
Summary Fields
Field: Last Year's Sales
Formula: Sum ({Customer.Last Year's Sales}, {Customer.Country})
Field: Last Year's Sales
Formula: Sum ({Customer.Last Year's Sales})
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: Charting
Text Field: Text2
Text: Drilldown on chart for details
Tool Tip Formula: "Vertical text is now available"
Text Field: Text3
Text: Add new charting features to your report
Tool Tip Formula: "Powerful new charting features allow for more control over charts and legends"
Pictures
Picture: Picture4
Size: 286x107
Lines
Line: Line1
Ends in Section: Section1
Line Type: Single
Line Thickness: 30
Charts
Chart: Graph1
Chart Type: Bar
Show value(s): Sum of (Customer.Last Year's Sales, Customer.Country)
Evaluate On: Customer.Country
Page Header
Section: Section a
Text Fields
Text Field: Text4
Text: Customer Name
Text Field: Text5
Text: Region
Text Field: Text6
Text: Country
Text Field: Text7
Text: Postal Code
Text Field: Text8
Text: Last Year's Sales
Groups
Group: Group #1
Grouped By: {Customer.Country}
Group Header
Section: Section a
Fields
Field: Field3
Data Source: GroupName ({Customer.Country})
Data Type: String
Group Footer
Section: Section a
Fields
Field: Field9
Data Source: Sum ({Customer.Last Year's Sales}, {Customer.Country})
Data Type: Number
Tool Tip Formula: "Rounded boxes now available"
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Text Fields
Text Field: Text9
Text: Subtotal
Boxes
Box: Box1
Ends in Section: Section5
Size: 104x26
Line Type: Single
Line Thickness: 20
Detail
Section: Section a
Fields
Field: Field4
Data Source: {Customer.Customer Name}
Data Type: String
Tool Tip Formula: "10.5pt font selection now available"
Field: Field5
Data Source: {Customer.Region}
Data Type: String
Tool Tip Formula: "10.5pt font selection now available"
Field: Field6
Data Source: {Customer.Postal Code}
Data Type: String
Tool Tip Formula: "10.5pt font selection is now available"
Field: Field7
Data Source: {Customer.Last Year's Sales}
Data Type: Number
Tool Tip Formula: "Add Conditional formatting to your fields. In this case, if amount is less than $1,000 then font appears in red."
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Field: Field8
Data Source: {Customer.Country}
Data Type: String
Tool Tip Formula: "10.5pt font selection now available"
Page Footer
Section: Section a
Fields
Field: Field11
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: Text11
Text: Crystal Decisions Support Site
Hyperlink: http://support.crystaldecisions.net
Tool Tip Formula: "Visit the support site for samples, web forums, tutorials, technical briefs and more!"
Text Field: Text12
Text: Feedback on Samples by E-mail
Hyperlink: mailto:feedbackSCR@crystaldecisions.net
Text Field: Text13
Text: © Copyright 2003 Crystal Decisions Inc. All Rights Reserved.
Pictures
Picture: Picture2
Size: 200x50
Hyperlink: http://www.crystaldecisions.com/
Tool Tip Formula: "http://www.crystaldecisions.com/"
Lines
Line: Line2
Ends in Section: Section7
Line Type: Single
Line Thickness: 30
Report Footer
Section: Section a
Fields
Field: Field10
Data Source: Sum ({Customer.Last Year's Sales})
Data Type: Number
Tool Tip Formula: "Rounded boxes now available"
Format: Number
Currency Type: Floating
Currency Symbol: $
Currency Position: Leading Outside Negative $-123
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: $-5,555,555.
Text Fields
Text Field: Text10
Text: Grand Total
Boxes
Box: Box2
Ends in Section: Section6
Size: 104x26
Line Type: Single
Line Thickness: 20