**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Feature Examples\Prompting.rpt **************************************************************************** Report Information Version: 11.0 Title: How To Use Dynamic Cascading Prompting 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: City Data Type: String Description: Enter City: List Type: Dynamic Dynamic Field: GeographyPrompt.City Default Values: ...All Parameter: Country Data Type: String Description: Enter Country: List Type: Dynamic Dynamic Field: GeographyPrompt.Country Default Values: USA Parameter: Region Data Type: String Description: Enter Region: List Type: Dynamic Dynamic Field: GeographyPrompt.Region Default Values: CA Parameter: Employee Data Type: Number Description: Enter Employee ID: List Type: Dynamic Dynamic Field: Employee.Employee ID Default Values: 3 4 Tables Table: Customer Connection: Connection #1 Used Columns: {Customer.Customer ID} : Number {Customer.Customer Name} : String[82] {Customer.Last Year's Sales} : Number {Customer.City} : String[42] {Customer.Region} : String[62] {Customer.Country} : String[62] Table: Employee Connection: Connection #1 Used Columns: {Employee.Employee ID} : Number {Employee.Last Name} : String[42] Table: Orders Connection: Connection #1 Used Columns: {Orders.Order ID} : Number {Orders.Order Amount} : Number {Orders.Customer ID} : Number {Orders.Employee ID} : Number {Orders.Order Date} : DateTime Table: Orders Detail Connection: Connection #1 Report Alias: Orders_Detail Used Columns: {Orders_Detail.Product ID} : Number {Orders_Detail.Unit Price} : Number {Orders_Detail.Quantity} : Number Table: Product Connection: Connection #1 Used Columns: {Product.Product ID} : Number {Product.Product Name} : String[102] Table: Command Connection: Connection #1 Report Alias: GeographyPrompt SQL Command: SELECT Country, Region, City FROM Customer UNION SELECT Country, Region, '...All' FROM Customer UNION SELECT Country, '...All', '...All' FROM Customer UNION SELECT '...All', '...All', '...All' FROM Customer Table Links Joins: Customer INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID] Customer INNER JOIN Command GeographyPrompt ON Customer.City,Region,Country = GeographyPrompt.City,Region,Country Orders INNER JOIN Employee ON Orders.[Employee ID] = Employee.[Employee ID] Orders INNER JOIN [Orders Detail] Orders_Detail ON Orders.[Order ID] = Orders_Detail.[Order ID] [Orders Detail] Orders_Detail INNER JOIN Product ON Orders_Detail.[Product ID] = Product.[Product ID] Record Selection Formulas Formula: if {?Country} = '...All' then {Orders.Employee ID}={?Employee} else if {?Region} = '...All' then {Orders.Employee ID}={?Employee} and {Customer.Country} = {?Country} else if {?City} = '...All' then {Orders.Employee ID}={?Employee} and {Customer.Country} = {?Country} and {Customer.Region} = {?Region} else {Orders.Employee ID}={?Employee} and {Customer.Country} = {?Country} and {Customer.Region} = {?Region} and {Customer.City} = {?City} Record Sorting Sort By: Customer.Customer Name -- Ascending Order Group #1 Orders.Order ID -- Ascending Order Group #2 Report Header Section: Section a Text Fields Text Field: Text1 Text: Prompting Text Field: Text16 Text: This report demonstrates the use of Command Objects and Report Fields to populate dynamic picklists. The Country, Region, and City parameter picklists are populated by the GeographyPrompt command object. The Employee parameter picklist is populated by values from the Employee table. The record selection formula is used to disable certain query conditions, depending on the values selected. Pictures Picture: RO_Xtreme_Logo Size: 279x111 Hyperlink: http://www.businessobjects.com Lines Line: Line1 Ends in Section: ReportHeaderSection1 Line Type: Single Line Thickness: 30 Groups Group: Group #1 Grouped By: {Customer.Customer Name} Group Header Section: Section a Fields Field: GroupNameCustomerName1 Data Source: GroupName ({Customer.Customer Name}) Data Type: String Field: LastYearsSales1 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. Text Fields Text Field: Text2 Text: {Customer.City}, {Customer.Region} {Customer.Country} Headings Heading: Text10 Text: Last Years Sales Group: Group #2 Grouped By: {Orders.Order ID} Group Header Section: Section a Fields Field: OrderAmount1 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: OrderID1 Data Source: {Orders.Order ID} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5555555 Field: OrderDate1 Data Source: {Orders.Order Date} Data Type: DateTime Format: Date and Time Order: Date Only Date Type: Custom DateTime Format: D-MMM-YY Field: LastName1 Data Source: {Employee.Last Name} Data Type: String Headings Heading: Text7 Text: Product ID Heading: Text8 Text: Unit Price Heading: Text9 Text: Quantity Heading: Text6 Text: Order Date: Heading: Text4 Text: Order ID: Heading: Text5 Text: Order Amount: Heading: Text11 Text: Product Name Heading: Text15 Text: Sales Person: Boxes Box: Box1 Ends in Section: GroupFooterSection2 Size: 767x105 Line Type: Single Line Thickness: 20 Detail Section: Section a Fields Field: ProductID1 Data Source: {Orders_Detail.Product ID} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5555555 Field: UnitPrice1 Data Source: {Orders_Detail.Unit Price} 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: Quantity1 Data Source: {Orders_Detail.Quantity} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5,555,555 Field: ProductName1 Data Source: {Product.Product Name} 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: Text13 Text: Business Objects Technical Support Site Hyperlink: http://support.businessobjects.com Text Field: Text12 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: Text14 Text: Feedback on Samples by E-mail Hyperlink: mailto:crfeedback@businessobjects.com Pictures Picture: Picture2 Size: 150x40 Hyperlink: http://www.businessobjects.com