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


Report Information
    Description    Converted from Crystal Reports by Crystal Reports Migration Services, contact 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 Employee_Addresses.Address1, Employee_Addresses.Address2, Employee_Addresses.City, Employee_Addresses.Region, Employee_Addresses.Country, Employee_Addresses.[Postal Code], Employee_Addresses.[Employee ID] 
                           FROM   [Employee Addresses] Employee_Addresses 
                           WHERE Employee_Addresses.[Employee ID] IN (@EmployeeID)
                           

            Parameters
                @EmployeeID    =Parameters!EmployeeID.Value

        Fields

            Address1
                Name    Address1
                Source    Address1
                Data Type    String

            Address2
                Name    Address2
                Source    Address2
                Data Type    String

            City
                Name    City
                Source    City
                Data Type    String

            Region
                Name    Region
                Source    Region
                Data Type    String

            Country
                Name    Country
                Source    Country
                Data Type    String

            Postal_Code
                Name    Postal_Code
                Source    [Postal Code]
                Data Type    String

            Employee_ID
                Name    Employee_ID
                Source    [Employee ID]
                Data Type    Int32

Parameters

    EmployeeID
        Name    EmployeeID
        Data Type    Float
        Prompt    EmployeeID

        Default Value

            Dataset Reference

        Valid Value

            Dataset Reference

Body

    Report Items

        RectDetailArea1
            Name    RectDetailArea1
            Type    Rectangle

        Text8
            Name    Text8
            Type    Text Box
            Content    =Fields!Address1.Value
                       =Fields!Address2.Value
                       =IIF ((IsNothing(Fields!Region.Value)), (Fields!City.Value) , ((Fields!City.Value + ", ") + Fields!Region.Value))
                       =Fields!Country.Value
                       =Fields!Postal_Code.Value

        Text9
            Name    Text9
            Type    Text Box
            Content    Home Address:

    Data Regions

        Tablix1
            Name    Tablix1
            Type    Table

            Row Member 1

                Details
                    Name    Details
            Source Dataset    DataSet1