Report Information
Version: 11.0
Author: Copyright © 2004 Business Objects
Title: How to group data
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]
Record Sorting
Sort By: Customer.Country -- Ascending Order Group #1
Customer.Customer Name -- Ascending Order
Summary Fields
Field: Last Year's Sales
Formula: Sum ({Customer.Last Year's Sales}, {Customer.Country})
Field: Last Year's Sales
Formula: PercentOfSum ({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: Grouping Data
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
Text Fields
Text Field: Text2
Text: Customer Name
Text Field: Text3
Text: Region
Text Field: Text4
Text: Percentage of Total Sales
Text Field: Text5
Text: Last Year's Sales
Text Field: Text6
Text: How to group data
Groups
Group: Group #1
Grouped By: {Customer.Country}
Group Header
Section: Section a
Fields
Field: Field3
Data Source: GroupName ({Customer.Country})
Data Type: String
Tool Tip Formula: "This data in this report is grouped by the field {Customer.Country}. Use Insert>Group to do this."
Field: Field9
Data Source: Sum ({Customer.Last Year's Sales}, {Customer.Country})
Data Type: Number
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: Field13
Data Source: PercentOfSum ({Customer.Last Year's Sales}, {Customer.Country})
Data Type: Number
Format: Number
Currency Type: Floating
Currency Symbol: %
Currency Position: Trailing Outside Negative -123%
Suppress if Zero: False
Leading Zero: True
Reverse Sign: False
Number Style: -5,555,555%.
Detail
Section: Section a
Fields
Field: Field4
Data Source: {Customer.Customer Name}
Data Type: String
Tool Tip Formula: "The records within the group GroupName {Customer.Country} are sorted alphabetically. Use Report>Sort Records to do this."
Field: Field7
Data Source: {Customer.Last Year's Sales}
Data Type: Number
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: Field14
Data Source: {Customer.Region}
Data Type: String
Page Footer
Section: Section a
Fields
Field: Field8
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: 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.
Text Field: Text9
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@businessobjects.com
Pictures
Picture: Picture2
Size: 150x40
Hyperlink: http://www.businessobjects.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
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.