****************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\en\Samples\Reports\General Business\Mailing Label.rpt
****************************************************************************


Report Information
    Version:    11.0
    Author:    Copyright © 2004 Business Objects
    Comments:    Mail labels with To: Department/Customer Name and Address, and From: Your Company Name and Address and company logo.
    Title:    Mail Labels
    Printer:    Unknown/Not Set

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 Name} : String[82]
                             {Customer.Address1} : String[122]
                             {Customer.Address2} : String[42]
                             {Customer.City} : String[42]
                             {Customer.Region} : String[62]
                             {Customer.Country} : String[62]
                             {Customer.Postal Code} : String[22]

    Formula Fields

        Field:    To city/state
            Formula:    if IsNull({Customer.Region}) then {Customer.City}
                        else
                        if IsNull({Customer.City}) then {Customer.Region}
                        else 
                        {Customer.City} + ", " + {Customer.Region}

        Field:    To Address
            Formula:    if IsNull ({Customer.Address2}) then {Customer.Address1}
                        else
                        {Customer.Address2} + ", " + {Customer.Address1}

    Detail

        Section:    Section a

            Fields

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

                Field:    Field2
                    Data Source:    {@To Address}
                    Data Type:    String

                Field:    Field3
                    Data Source:    {@To city/state}
                    Data Type:    String

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

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

            Text Fields

                Text Field:    Text1
                    Text:    To:

                Text Field:    Text2
                    Text:    Attn: Shipping/Receiving
                    Tool Tip Formula:    "Crystal Reports features better control over the positioning of report objects" 
                                         
                                         

                Text Field:    Text3
                    Text:    Xtreme Mountain Bikes, Inc.
                    Tool Tip Formula:    "Seagate Crystal Reports 8 features better control over the positioning of report objects" 
                                         

                Text Field:    Text4
                    Text:    2001 Meridian Way

                Text Field:    Text5
                    Text:    Vancouver, BC

                Text Field:    Text6
                    Text:    Canada, V6G 3G6

            Pictures

                Picture:    Picture1
                    Size:    120x52
                    Hyperlink:    http://www.businessobjects.com
                    Tool Tip Formula:    
                                         

            Boxes

                Box:    Box1
                    Ends in Section:    Section3
                    Size:    384x190
                    Line Type:    Single
                    Line Thickness:    10

                Box:    Box2
                    Ends in Section:    Section3
                    Size:    71x187
                    Line Type:    Single
                    Line Thickness:    0

            Lines

                Line:    Line1
                    Ends in Section:    Section3
                    Line Type:    Single
                    Line Thickness:    50