Make a Report Context-Sensitive
The following steps describe how to set up a context-sensitive report in Microsoft CRM.
- 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
- When you upload the report to Microsoft CRM through the Report: New form, select all entities in the Related Record Types categorization whose filtered views are referred to in the report's SQL code.
- In the Display in field of the form, Forms for related record types must be one of the selected values.
For example, if a report displays all activities for a particular account and you would like to show this report on the Microsoft 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.
© 2007 Microsoft Corporation. All rights reserved.