**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\Running Totals Group.rpt **************************************************************************** Report Information Version: 11.0 Author: © 2002 Crystal Decisions, Inc. 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: 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: 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 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. Field: Field10 Data Source: {Customer.Customer Name} Data Type: String 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: Crystal Care Support Site Hyperlink: http://support.crystaldecisions.com Text Field: Text8 Text: © Copyright 2002 Crystal Decisions, Inc. All Rights Reserved. Text Field: Text9 Text: Feedback on Samples by E-mail Hyperlink: mailto:crfeedback@crystaldecisions.com Pictures Picture: Picture2 Size: 179x50 Hyperlink: http://www.crystaldecisions.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