I'm trying to use the DataSet from Entity Framework for RDLC.
The entity is something like this:
Department:
DepartmentId
Name
Employee:
EmployeeId
DepartmentId -> FK to Department
Name
When I'm iterating the employees, is it possible get the department name?
I've tried some things like =Fields!Department.Value.Name.Value or =Fields!Department.Name.Value. But it won't work.
Any help is appreciated. Thanks. =)
Edit: Sorry if the title is kind of confusing, but I just can't explain it.