****************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\Feature Examples\Alerting.rpt
****************************************************************************


Report Information
    Version:    11.0
    Author:    Copyright © 2004 Business Objects
    Title:    Alerting Report
    Subject:    Alerting feature.
    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:    Amount of Sales
            Data Type:    Number
            Description:    Please enter a number to see sales greater than this amount
            List Type:    Static
            List Values:    1000
                            2000
                            5000
                            10000
            Default Values:    5000

    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:    Country
            Formula:    Count ({Customer.Country}, {Customer.Country})

    Triggered Alerts

        Alert:    Sales
            Message:    Sales are greater than 5,000.00
            Message Formula:    "Sales are greater than " + totext({?Amount of Sales})
            Condition:    {Customer.Last Year's Sales}> {?Amount of Sales}

    Report Header

        Section:    Section a

            Fields

                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

                Field:    Field3
                    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:    Text10
                    Text:    Alerting Report

            Pictures

                Picture:    RO_Xtreme_Logo
                    Size:    279x111
                    Hyperlink:    http://www.businessobjects.com

            Lines

                Line:    Line2
                    Ends in Section:    Section3
                    Line Type:    Single
                    Line Thickness:    30

    Page Header

        Section:    Section a

            Text Fields

                Text Field:    Text1
                    Text:    Customer Name

                Text Field:    Text2
                    Text:    Region

                Text Field:    Text3
                    Text:    Country

                Text Field:    Text4
                    Text:    Postal Code

                Text Field:    Text5
                    Text:    Last Year's Sales

    Groups

        Group:    Group #1
            Grouped By:    {Customer.Country}

            Group Header

                Section:    Section a

                    Fields

                        Field:    Field4
                            Data Source:    GroupName ({Customer.Country})
                            Data Type:    String

            Group Footer

                Section:    Section a

                    Fields

                        Field:    Field5
                            Data Source:    Count ({Customer.Country}, {Customer.Country})
                            Data Type:    Number
                            Tool Tip Formula:    "Country Count is generated by using Insert>Summary and by creating a simple formula. See Insert>Formula Field for details." 
                                                 
                            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:    Customers in this country =
                            Tool Tip Formula:    "Country Count is generated by using Insert>Summary and by creating a simple formula. See Insert>Formula Field for details."   
                                                 

                    Lines

                        Line:    Line3
                            Ends in Section:    Section6
                            Line Type:    Single
                            Line Thickness:    20

    Detail

        Section:    Section a

            Fields

                Field:    Field6
                    Data Source:    {Customer.Customer Name}
                    Data Type:    String

                Field:    Field7
                    Data Source:    {Customer.Region}
                    Data Type:    String

                Field:    Field8
                    Data Source:    {Customer.Postal Code}
                    Data Type:    String

                Field:    Field9
                    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.

                Field:    Field10
                    Data Source:    {Customer.Country}
                    Data Type:    String

    Page Footer

        Section:    Section a

            Fields

                Field:    Field1
                    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:    Text6
                    Text:    Business Objects Technical Support Site
                    Hyperlink:    http://support.businessobjects.com

                Text Field:    Text7
                    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:    Text8
                    Text:    Feedback on Samples by E-mail
                    Hyperlink:    mailto:crfeedback@businessobjects.com

            Pictures

                Picture:    Picture2
                    Size:    150x40
                    Hyperlink:    http://www.businessobjects.com

            Lines

                Line:    Line1
                    Ends in Section:    Section2
                    Line Type:    Single
                    Line Thickness:    30