****************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Mailing Label.rdl
****************************************************************************


Report Information
    Description    Report Title: Mail Labels
                   Report Author: Copyright © 2004 Business Objects
                   Report Comments: Mail labels with To: Department/Customer Name and Address, and From: Your Company Name and Address and company logo.
                   Converted By: Crystal Migration Services, support@crystalmigrater.com

Data Sources

    DataSource1
        Name    DataSource1
        Connection String    DSN=Xtreme Sample Database 11.5;
        Data Provider    ODBC

Datasets

    DataSet1
        Name    DataSet1

        Query
            Data Source    DataSource1
            CommandText    
                           SELECT Customer.Region, Customer.City, Customer.Address2, Customer.Address1, Customer.[Customer Name], Customer.[Postal Code], Customer.Country 
                           FROM   Customer Customer

            Parameters

        Fields

            Region
                Name    Region
                Source    Region
                Data Type    String

            City
                Name    City
                Source    City
                Data Type    String

            Address2
                Name    Address2
                Source    Address2
                Data Type    String

            Address1
                Name    Address1
                Source    Address1
                Data Type    String

            Customer_Name
                Name    Customer_Name
                Source    [Customer Name]
                Data Type    String

            Postal_Code
                Name    Postal_Code
                Source    [Postal Code]
                Data Type    String

            Country
                Name    Country
                Source    Country
                Data Type    String

Embedded Images

    Picture_5494AAD0F891ACBDCD689F0B6EB8627C
        Name    Picture_5494AAD0F891ACBDCD689F0B6EB8627C
        Type    jpeg

Body

    Report Items

        MultiCol_Contents
            Name    MultiCol_Contents
            Type    Rectangle

        InnerMatrix_Rectangle
            Name    InnerMatrix_Rectangle
            Type    Rectangle

        Box1
            Name    Box1
            Type    Rectangle

        Box2
            Name    Box2
            Type    Rectangle

        Text1
            Name    Text1
            Type    Text Box
            Content    To:

        Text2
            Name    Text2
            Type    Text Box
            Content    Attn: Shipping/Receiving

        Customer_Name
            Name    Customer_Name
            Type    Text Box
            Content    =Fields!Customer_Name.Value

        Field2_To_Address
            Name    Field2_To_Address
            Type    Text Box
            Content    =IIF ((IsNothing(Fields!Address2.Value)), (Fields!Address1.Value) , ((Fields!Address2.Value + ", ") + Fields!Address1.Value))

        Field3_To_city_state
            Name    Field3_To_city_state
            Type    Text Box
            Content    =IIF ((IsNothing(Fields!Region.Value)), (Fields!City.Value), IIF (( IsNothing(Fields!City.Value) ), (Fields!Region.Value) , ((Fields!City.Value + ", ") + Fields!Region.Value)))

        Postal_Code
            Name    Postal_Code
            Type    Text Box
            Content    =Fields!Postal_Code.Value

        Country
            Name    Country
            Type    Text Box
            Content    =Fields!Country.Value

        Text3
            Name    Text3
            Type    Text Box
            Content    Xtreme Mountain Bikes, Inc.

        Text4
            Name    Text4
            Type    Text Box
            Content    2001 Meridian Way

        Text5
            Name    Text5
            Type    Text Box
            Content    Vancouver, BC

        Text6
            Name    Text6
            Type    Text Box
            Content    Canada, V6G 3G6

        Picture1
            Name    Picture1
            Type    Image
            Source Type    Embedded Image Name
            Embedded Image Name    Picture_5494AAD0F891ACBDCD689F0B6EB8627C

            Actions
                Go to URL    http://www.businessobjects.com

    Data Regions

        MultiCol
            Name    MultiCol
            Type    Table

            Row Member 1

                MultiCol_Details_Group
                    Name    MultiCol_Details_Group
                    Expressions    =Ceiling(RowNumber(Nothing)/2)
            Source Dataset    DataSet1

        InnerMatrix
            Name    InnerMatrix
            Type    Table

            Column Member 1

                InnerMatrix_ColumnGroup
                    Name    InnerMatrix_ColumnGroup
                    Expressions    =RowNumber("MultiCol_Details_Group")
            Source Dataset    DataSet1