Report Information
Version: 10.2
Author: Copyright © 2004 Business Objects
Title: How to group data in intervals
Printer: Unknown/Not Set
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 Sorting
Sort By: Customer.Last Year's Sales -- Original Order Group #1
Customer.Customer Name -- Ascending Order
Summary Fields
Field: Last Year's Sales
Formula: Sum ({Customer.Last Year's Sales}, {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: Group Data in Intervals
Pictures
Picture: Picture4
Size: 286x107
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: Country
Text Field: Text5
Text: Last Year's Sales
Text Field: Text6
Text: How to group data in intervals
Text Field: Text7
Text: Postal Code
Groups
Group: Group #1
Grouped By: {Customer.Last Year's Sales}
Group Header
Section: Section a
Fields
Field: Field3
Data Source: GroupName ({Customer.Last Year's Sales})
Data Type: String
Tool Tip Formula: "Group data in intervals by selecting Report>Change Group Expert once your group section has been created"
Group Footer
Section: Section a
Fields
Field: Field9
Data Source: Sum ({Customer.Last Year's Sales}, {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.
Text Fields
Text Field: Text8
Text: Total:
Detail
Section: Section a
Fields
Field: Field4
Data Source: {Customer.Customer Name}
Data Type: String
Field: Field5
Data Source: {Customer.Postal Code}
Data Type: String
Field: Field6
Data Source: {Customer.Country}
Data Type: String
Field: Field7
Data Source: {Customer.Last Year's Sales}
Data Type: Number
Tool Tip Formula: "Group data in intervals by selecting Report>Change Group Expert once your group section has been created"
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.Region}
Data Type: String
Page Footer
Section: Section a
Fields
Field: Field10
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: Text9
Text: Business Objects Technical Support Site
Hyperlink: http://support.businessobjects.com
Text Field: Text10
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: Text11
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