Report Information
Version: 11.0
Author: Copyright © 2004 Business Objects
Title: How to maintain running totals for a group
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 ID} : Number
{Customer.Customer Name} : String[82]
Table: Orders
Connection: Connection #1
Used Columns: {Orders.Order Amount} : Number
{Orders.Customer ID} : Number
{Orders.Shipped} : Boolean
Table Links
Joins: Customer INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
Record Sorting
Sort By: Customer.Customer Name -- Ascending Order Group #1
Orders.Shipped -- Ascending Order
Running Totals
Running Total: GroupRunningTotal
Field: GroupRunningTotal
Type: GroupRunningTotal
Evaluate: GroupRunningTotal
Evaluate Condition: GroupRunningTotal
Reset: GroupRunningTotal
Reset Condition: GroupRunningTotal
Running Total: Conditional_GroupRunningTotal
Field: Conditional_GroupRunningTotal
Type: Conditional_GroupRunningTotal
Evaluate: Conditional_GroupRunningTotal
Evaluate Condition: Conditional_GroupRunningTotal
Reset: Conditional_GroupRunningTotal
Reset Condition: Conditional_GroupRunningTotal
Running Total: GrandRunningTotal
Field: GrandRunningTotal
Type: GrandRunningTotal
Evaluate: GrandRunningTotal
Evaluate Condition: GrandRunningTotal
Reset: GrandRunningTotal
Reset Condition: GrandRunningTotal
Running Total: GrandConditional_RunningTotal
Field: GrandConditional_RunningTotal
Type: GrandConditional_RunningTotal
Evaluate: GrandConditional_RunningTotal
Evaluate Condition: GrandConditional_RunningTotal
Reset: GrandConditional_RunningTotal
Reset Condition: GrandConditional_RunningTotal
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: Running Totals for a Group
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: Text4
Text: Order Amount
Text Field: Text5
Text: RunningTotal
Text Field: Text6
Text: How to maintain running totals for a group
Text Field: Text10
Text: RunningTotal
(Only Shipped Values)
Headings
Heading: Text3
Text: Shipped
Group Selection Formula
Formula: minimum({Orders.Shipped},{Customer.Customer Name}) = False
Groups
Group: Group #1
Grouped By: {Customer.Customer Name}
Group Header
Section: Section a
Fields
Field: Field3
Data Source: GroupName ({Customer.Customer Name})
Data Type: String
Group Footer
Section: Section a
Fields
Field: Field8
Data Source: {#GroupRunningTotal}
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: Field11
Data Source: {#Conditional_GroupRunningTotal}
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.
Detail
Section: Section a
Fields
Field: Field6
Data Source: {Orders.Order Amount}
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: Field7
Data Source: {#GroupRunningTotal}
Data Type: Number
Tool Tip Formula: "Running Total is the cumulative sum of {Orders.Order Amount}. Use Insert>Running Total Field to do this."
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: Field4
Data Source: {Orders.Shipped}
Data Type: Boolean
Field: Field5
Data Source: {#Conditional_GroupRunningTotal}
Data Type: Number
Tool Tip Formula: "Running Total is the cumulative sum of {Orders.Order Amount} based on Order being shipped. Use Insert>Running Total Field (EVALUATE = 'Use a Formula') to do this."
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: Field9
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: Field12
Data Source: {#GrandRunningTotal}
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: {#GrandConditional_RunningTotal}
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: Text11
Text: Grand Total