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 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.