**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Feature Examples\Group Selection.rpt **************************************************************************** Report Information Version: 11.0 Author: Copyright © 2004 Business Objects Title: How to create group selection based on countries with sales based on the parameter values 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 Report Parameters Parameter: Over/Under Data Type: String Description: Choose over or under List Type: Static List Values: Over Under Default Values: Over Parameter: Value Data Type: Number Description: Enter Value for Countries subtotal: List Type: Static Default Values: 10000 Parameter: Sort Order Data Type: Number Description: Enter Sort Order: List Type: Static List Values: 0 - Ascending 1 - Descending Default Values: 0 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.Country -- Ascending Order Group #1 Summary Fields Field: Last Year's Sales Formula: Sum ({Customer.Last Year's Sales}, {Customer.Country}) 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 Selection 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: Text7 Text: How to create group selection based on countries with sales {?Over/Under} {?Value} Section: Section b Text Fields Text Field: Text6 Text: Last Year's Sales Text Field: Text5 Text: Postal Code Text Field: Text4 Text: Country Text Field: Text3 Text: Region Text Field: Text2 Text: Customer Name Group Selection Formula Formula: //Return only those groups with Last Years Sales that meet the parameter entries. //Example: If user chooses 'Over' for the ?Over/Under parameter and a value of $100 //for the ?Value parameter, the report will only return those groups where the //Sum of Last Years Sales per Country is greater than $100. if {?Over/Under} = "Over" then Sum ({Customer.Last Year's Sales}, {Customer.Country}) >= {?Value} else if {?Over/Under} = "Under" then Sum ({Customer.Last Year's Sales}, {Customer.Country}) <= {?Value} Groups Group: Group #1 Grouped By: {Customer.Country} Group Header Section: Section a Fields Field: Field3 Data Source: GroupName ({Customer.Country}) Data Type: String Group Footer Section: Section a Fields Field: Field9 Data Source: Sum ({Customer.Last Year's Sales}, {Customer.Country}) Data Type: Number Tool Tip Formula: "This report only shows countries whose sales totals are based on the values entered in the parameter. Use Report>Select Expert 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. Detail Section: Section a Fields Field: Field4 Data Source: {Customer.Customer Name} Data Type: String Tool Tip Formula: "Choose only the groups you want to see in your report. Use Report>Select Expert to do this." Field: Field5 Data Source: {Customer.Region} Data Type: String Field: Field6 Data Source: {Customer.Postal Code} Data Type: String Field: Field7 Data Source: {Customer.Country} Data Type: String Field: Field8 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. 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: Text8 Text: Business Objects Technical Support Site Hyperlink: http://support.businessobjects.com Text Field: Text9 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: Text10 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