Skip to main content
Error on Activity report

 

Hi, I am helping someone to troubleshoot a report. She is running an Activities with Contacts report to measure volunteer time on a regular basis. The Task and Activity object has been customized to suit the needs for entering volunteer information. The issue is that when she runs the report for last year the date always shows the records from yesterday and not from January 1st as the filter shows. "Date" is the filter for Previous Calendar Year (1/1/18 - 12/31/18) - by Calendar Month.  "Activity Date" is a formula pulling from "Due Date", its a custom formula that have been created. Both Activity Date and Created Date were added to the report and they are the same. The report is a Summary type report grouped by volunteer category and contact id.

 

Why would the report not return all the data? I was thinking because some of the fields were not filled out(when I tested in my system it would give all the records), but its not the case as she has all related fields filled out. She has full access to these records so that cannot be the reason. Anyone has an idea why the report would not return certain records or full number of records. It could be hierarchy with the records?(Activity/Contact)

 

This way the report is incomplete and honestly I can`t find whether the error is in the report or in the configuration.

 

Error on Activity report

 

Report customize view

 

. Activity fields

 

Report filters

 

Volunteer Task

 

 
2 个回答
  1. 2019年3月13日 18:43
    Hi,

     

    You may check the related article below for additional info about your issue:

     

    Reports do not display all records or shows incorrect results

     

    https://help.salesforce.com/articleView?id=000005085&type=1

     

    Also, there are discussion trends that are likely similar to your concern.

     

    https://success.salesforce.com/answers?id=9063A000000l4UOQAY

     

    https://success.salesforce.com/apex/answers?id=9063A0000019TIQQA2

     

    https://success.salesforce.com/answers?id=9063A000000Dn1JQAS