Print this page

How to show Activity Name field on Reports for Accounts without Contacts

Knowledge Article Number 000240774
Description Report which displays All Activities for Accounts without a Contact associated using Activity Name field.
Resolution As per Standard Report Type on Activities with Accounts, you will not be able to view Activity Name field.

There is as workaround, Please find the below steps:

1.Create a Custom Report Type on Accounts object:

       a. Click Setup | Create | Report Types | New Custom report Type | 
       b. Primary Object | Accounts
       c. Add all required Fields.
       d. Deployment Status : Deployed
       e. Click Next
       f. Select Object: Activities
       g. Select: Each "A" record must have at least one related "B" record.
       h. Click Save.
2.Create a New Report using the above (Created) Custom Report Type.

      a. Add the Activity Name and other fields and set the Date range as per the requirement.
      b. Add a Filter on the report which states as below : (Under Activities you will find the field)
                      Name: Name EQUALS ""
      c. Click Run Report and Save.

See Also:

Activity Reports

Reports That You Can Run on Activities


promote demote