rdlc foriegn key lookup RRS feed

  • Question

  • Hello everyone,

    Short version: how can I display fields in a lookup table in a Table control in an RDLC?

    I have two strongly typed DataSets in my application, one contains lookup tables, the other lets say employee information.

    In LookupDataSet:
    SalaryGradeID int PK
    Name string
    Description string

    In EmployeeDataSet:
    EmployeeID int PK
    Name string
    HireDate datetime
    SalaryGradeID int FK (SalaryGrade)

    I have an RDLC with a Table with the DataSetName property set to EmployeeDataSet.  The columns for Name and HireDate load fine for each empolyee. 

    How can I display the Name field of the SalaryGrade table for the Employee's SalaryGradeID?

    Thank you

    Tuesday, August 19, 2008 6:24 PM