Dynamics CRM运行报告中的数据重复

Question

每一个我都创建了一个关于案例实体的报告。它将填充特定案例的相关记录，同时打开案例表单。它在做这项工作，但有一个问题。它在重复记录。例如，如果一个案例有7个相关活动，如电子邮件、电话、信件等，那么它只会显示7次电子邮件。我有以下疑问：

SELECT        
    activitytypecodename AS 'type', 
    regardingobjectidname AS 'regarding', 
    subject AS 'Subject', 
    statecodename AS 'status',
    prioritycodename AS 'priority', 
    new_casenumber AS 'casenumber'
FROM            
    FilteredActivityPointer AS CRMAF_FilteredActivityPointer 
INNER JOIN
        FilteredIncident AS CRMAF_FilteredIncident 
ON 
    CRMAF_FilteredIncident.incidentid = CRMAF_FilteredActivityPointer.regardingobjectid

下面是我得到的结果

请给出您的建议，并帮助解决问题。

Answer 1

尝试将查询修改为以下内容

SELECT        
AP.activitytypecodename AS 'type', 
AP.regardingobjectidname AS 'regarding', 
AP.subject AS 'Subject'
--statecodename AS 'status',
--prioritycodename AS 'priority'
FROM     FilteredIncident AS CRMAF_FilteredIncident
INNER JOIN FilteredActivityPointer AS AP ON 
CRMAF_FilteredIncident.incidentid = AP.regardingobjectid