Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Want to know Table relation between Service activity and Res
vrinda
Member Posts: 2
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
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
0
Comments