This is a basic overview to explain why some records do not appear as expected in an Activity report despite having record access.
Note: Activities captured with Einstein Activity Capture are not visible in core reporting. To view those Activities, review the Activities dashboard in Tableau CRM.
To ensure that your Activity Reports display the correct details, consider the following:
1. Pay attention to the Role Hierarchy
Users at any role level can view, edit, and report on all data that are owned by or shared with users below them in their role hierarchy. Unless your org’s sharing model for an object specifies otherwise.
If an Activity's owner does not have an assigned role, the activity does not appear in reports.
Review the following articles for more information:
2. Check to see if the Activity you want to display is archived
To help Salesforce run as efficiently as possible, Events with a due date greater than 365 days old, closed Tasks with due dates greater than 365 days old, and closed Tasks without a due date that were created more than 365 days ago are archived and made unavailable in reports, list views, and search. Archived Activities can be viewed on record pages or extracted via API.
See also: Increase 'Archive Days' for your organization
For example, suppose the Truck account belongs to Jack, and Josh creates a task related to that account. The WhatId field will be populated with the ID of the Truck account. Therefore, when running an "Accounts with Activities" report, the task created by Josh will appear because it is linked to the account.
000386026

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.