Loading

Report Returns Different Record Counts to Different Users

Julkaisupäivä: Oct 13, 2022
Kuvaus
If you have two Users that are showing different results for the same report and would like to determine the reason why, try the following troubleshooting steps.
Ratkaisu
 
  1. Log in as User 1 and run the report
  2. Copy the URL for the report, and in a new window, login as User 2 and paste the Report URL. This will ensure that you are going to the correct report.
    • You will be able to see if there are any differences in the Filters or Fields shown. If there is a discrepancy, the Field-Level Security for the missing field(s) may not be visible to the User. Setting this visibility through the profile or the field itself should resolve this issue
    • Check the “View Field Accessibility” apart from Field-Level Security
    • If there are no differences between the Filters or Fields, the issue may lie within the Sharing Settings and the User's Role
    • If the Sharing Settings are set to Private, the User may be unable to view certain records due to their assigned Role
    • To determine what records are missing, you may want to export both Reports with a unique value, such as Record ID, and merge the results. In a spreadsheet, highlight the duplicate values and sort by cell color. This will leave you with the records not visible to one User. From here, you can determine the best solution for Granting Access to Records, or you can create Sharing Rules for those records.
  3. Finally, if none of the above steps resolves the issue, and your report has a date filter, there may be a time zone difference between the Users. Find the missing records using the above method while logged in as each User and locate any discrepancies between the two.

If none of the above resolves the issue, please contact the Salesforce Support Team for assistance.
Knowledge-artikkelin numero

000386455

 
Ladataan
Salesforce Help | Article