Report Information
Version: 11.0
Author: © 2002 Crystal Decisions Inc.
Comments: This report shows how to group the records with a hierarchical structure.
Title: Hierarchical Grouping
Keywords: Hierarchical report, HR, grouping
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: Employee
Connection: Connection #1
Used Columns: {Employee.Employee ID} : Number
{Employee.Supervisor ID} : Number
{Employee.Last Name} : String[42]
{Employee.First Name} : String[22]
{Employee.Position} : String[62]
{Employee.Salary} : Number
Record Sorting
Sort By: Employee.Employee ID -- Ascending Order Group #1
Summary Fields
Field: Salary
Formula: Sum ({Employee.Salary}, {Employee.Employee ID})
Report Header
Section: Section a
Text Fields
Text Field: Text1
Text: Hierarchical Grouping
Text Field: Text2
Text: How to group with a hierarchical structure
Pictures
Picture: Picture4
Size: 286x107
Lines
Line: Line1
Ends in Section: Section1
Line Type: Single
Line Thickness: 30
Page 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: Text3
Text: Name
Text Field: Text5
Text: Salary
Text Field: Text9
Text: Position
Text Field: Text4
Text: Total
Lines
Line: Line2
Ends in Section: Section2
Line Type: Single
Line Thickness: 40
Groups
Group: Group #1
Grouped By: {Employee.Employee ID}
Name Formula: {Employee.First Name} + " " + {Employee.Last Name}
Group Header
Section: Section a
Fields
Field: Field3
Data Source: GroupName ({Employee.Employee ID})
Data Type: String
Field: Field6
Data Source: {Employee.Salary}
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: Field10
Data Source: {Employee.Position}
Data Type: String
Field: Field11
Data Source: Sum ({Employee.Salary}, {Employee.Employee ID}, "", "hierarchical")
Data Type: Number
Tool Tip Formula: "To summarize a value based on the hierarcy, right click on field to summarize -> choose Insert Summary -> turn on 'Summarize across hierarchy' option"
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.
Page Footer
Section: Section a
Fields
Field: Field7
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: Text6
Text: Feedback on Samples by E-mail
Hyperlink: mailto:crfeedback@crystaldecisions.com
Text Field: Text7
Text: © Copyright 2002 Crystal Decisions, Inc. All Rights Reserved.
Text Field: Text8
Text: Crystal Care Support Site
Hyperlink: http://support.crystaldecisions.com
Pictures
Picture: Picture3
Size: 179x50
Hyperlink: http://www.crystaldecisions.com
Lines
Line: Line3
Ends in Section: Section7
Line Type: Single
Line Thickness: 30