---
schema_version: "1"
id: d83ad9336c9cf627cdfbf40cff105803ebd824415c740f908f871ddf6f441efd
title: Why aren't middle names appearing in full name fields on reports?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/troubleshoot_reports_fullname_excludes_middlename.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.troubleshoot_reports_fullname_excludes_middlename.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e944ee34650bb9b3e8b3640c29fa81f2e452b5380279bc6ca004864afaa9be96
description: If your org has Enable Middle Names for Person Names turned on, which adds a "Middle Name" field to standard objects like users, leads, and contacts, then you may notice that the "Full Name" field on reports excludes middle names.
products:
  - Cross Cloud
release: "264"
---
# Why aren't middle names appearing in full name fields on reports?

If your org has **Enable Middle Names for Person Names** turned on, which adds a "Middle Name" field to standard objects like users, leads, and contacts, then you may notice that the "Full Name" field on reports excludes middle names.

For example, if a user's first, middle, and last name are Nadia Nancy Smith, then in reports the full name appears as "Nadia Smith".

As a work-around, consider adding a person's middle name to their "First Name" field; "Nadia" would become "Nadia Nancy".

A missing middle name could cause issues if you are filtering reports on the "Full Name" field, because filtering by Full Name equals Nadia Nancy Smith doesn't return the user. Instead, filter the report by Full Name equals Nadia Smith or add three filters:

- First Name equals Nadia
- Middle Name equals Nancy
- Last Name equals Smith

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)

Note Case reports and Lead reports are affected by the discrepancy between Full Name and Middle Name described in this article. Other reports may also be affected, but not all reports are.