Sample: Make a Report Context-Sensitive
The following steps describe how to set up a context-sensitive report in Microsoft Dynamics CRM.
For example, if a report displays all activities for a particular account and you want to show this report on the Microsoft Dynamics CRM Account form, you must include Activities and Accounts in the Related Record Types categorization and specify Forms for related record types in the Display in field of the Report: New form.
Create and configure a context-sensitive report
Create a report that contains fields from a Filtered<entity> database view and establish one or more SQL JOINs with other related filtered views as required.
Use CRMAF_Filtered<entity> as an alias name in the report's SQL query statement. For example:
SELECT CRMAF_FilteredActivityPointer.activitytypecodename as activitytypecodename, CRMAF_FilteredActivityPointer.regardingobjectidname as regardingobjectidname, CRMAF_FilteredActivityPointer.subject as subject, CRMAF_FilteredAccount.name FROM FilteredActivityPointer AS CRMAF_FilteredActivityPointer INNER JOIN FilteredAccount As CRMAF_FilteredAccount on CRMAF_FilteredAccount.accountid = CRMAF_FilteredActivityPointer.regardingobjectid
If you have a fetch-based report, you can use the following FetchXML query instead of the SQL query:
<fetch> <entity name="activitypointer" enableprefiltering="1" > <attribute name="activitytypecode" /> <attribute name="regardingobjectid" /> <attribute name="subject" alias="subject" /> <link-entity name="account" from="accountid" to="regardingobjectid" link-type='inner' alias="accountLink"> <attribute name="name" alias="name" /> </link-entity> </entity> </fetch>
When you upload the report to Microsoft Dynamics CRM through the Report: New form, select all entities in the Related Record Types categorization that filtered views are referred to in the report's SQL code.
In Display In field, select Forms for related record types or Lists for related record types. Selecting Lists for related record types enables you to run a report from the entity list grid. Selecting Forms for related record types lets you run a report from the entity form.
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.