**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Feature Examples\Accessibility.rpt **************************************************************************** Report Information Version: 11.0 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: Accessible Data Type: Boolean Description: Accessibility Mode: List Type: Static List Values: True - Accessible False - Normal Default Values: True Initial Values: False Tables Table: Customer Connection: Connection #1 Used Columns: {Customer.Customer ID} : Number {Customer.Customer Credit ID} : Number {Customer.Customer Name} : String[82] {Customer.Contact First Name} : String[62] {Customer.Contact Last Name} : String[62] Table: Credit Connection: Connection #1 Used Columns: {Credit.Credit Authorization Number} : String[22] {Credit.Customer Credit ID} : Number {Credit.Amount} : Number Table Links Joins: Customer INNER JOIN Credit ON Customer.[Customer Credit ID] = Credit.[Customer Credit ID] Record Sorting Sort By: Customer.Customer ID -- Ascending Order Group #1 Customer.Contact Last Name -- Ascending Order Group #2 Formula Fields Field: Contact name Formula: "Contact: " + {Customer.Contact First Name} + " " + {Customer.Contact Last Name} Page Header Section: Section a Fields Field: PrintTime1 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 Field: Field2 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 Text Fields Text Field: Text1 Text: Accessibility Report Text Field: Text2 Text: By Customer Text Field: Text4 Text: Credit Amount Suppression Formula: {?Accessible}=true Text Field: Text3 Text: Credit Authorization Number Suppression Formula: {?Accessible}=true Lines Line: Line1 Ends in Section: PageHeaderSection1 Line Type: Single Line Thickness: 30 Groups Group: Group #1 Grouped By: {Customer.Customer ID} Group Header Section: Section a Conditional Formulas Condition: BackgroundColor Formula: // This conditional formatting formula must return one of the following Color Constants: // // Color (red, green, blue) // crBlack // crMaroon // crGreen // crOlive // crNavy // crPurple // crTeal // crSilver // crRed // crLime // crYellow // crBlue // crFuchsia // crAqua // crWhite // crNoColor // if {?Accessible} = True then white else color(249,211,124) Fields Field: CustomerName1 Data Source: {Customer.Customer Name} Data Type: String Text Fields Text Field: Text7 Text: Total Credit Amount Sum ({Credit.Amount}, {Customer.Customer ID}) Group: Group #2 Grouped By: {Customer.Contact Last Name} Group Header Section: Section a Fields Field: Contactname1 Data Source: {@Contact name} Data Type: String Detail Section: Section a Conditional Formulas Condition: EnableSuppress Formula: {?Accessible}=false Fields Field: CreditAuthorizationNumber2 Data Source: {Credit.Credit Authorization Number} Data Type: String Field: Amount2 Data Source: {Credit.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. Text Fields Text Field: Text9 Text: Authorization Number Text Field: Text6 Text: Amount Section: Section b Conditional Formulas Condition: EnableSuppress Formula: {?Accessible}=true Fields Field: CreditAuthorizationNumber1 Data Source: {Credit.Credit Authorization Number} Data Type: String Field: Amount1 Data Source: {Credit.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. Page Footer Section: Section a Fields Field: Field15 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: Text11 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: Text13 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: PageFooterSection1 Line Type: Single Line Thickness: 20