Monday, November 26, 2007

Report "Quick campaign" Microsoft Crm 3.0

One thing hard to get is "Quick campaign" report in Microsoft CRM 3.0, and after this litle example, you can work out and try to make a report like Campaign.

select fbo.subject, fap.activitytypecodename, *
from [companyname]_MSCRM.dbo.filteredbulkoperation fbo,
[companyname]_MSCRM.dbo.filteredactivitypointer fap
where fbo.operationtypecodename='Quick Campaign'
and fbo.activityid=fap.regardingobjectid

No comments: