Want to know Table relation between Service activity and Res

vrinda
vrinda Member Posts: 2
edited 2009-03-20 in Dynamics CRM
Hi all,
I want to create one report in CRM 4.0 using SQL Reporting services with the following specification. Report should list out all Service activity (Resource person wise). But there is no link between the tables Service Activity and Resource Base. In CRM when creating service activity, it is possible to lookup the resource field and retrieves it. But in Back End (In SQL Server 2008), not able to find out the table relation. I want to know how to relate these two tables.
Thanks in Advance,
Vrinda

Comments

  • Administrator
    Administrator Member, Moderator, Administrator Posts: 2,506
    [Removed Topic Attribute "Good Posting". This is not meant to attract people to your posting!]

Categories