Salesforce Reports Automatically Use the 18-Character Record ID When Filtering by Record ID

Salesforce report filters internally use the 18-character record ID format, also known as the case-safe ID. The report user interface displays only the 15-character ID in the column view. Both IDs refer to the same record, and the automatic conversion to 18 characters is by design.

How to Display the 18-Character Record ID in a Report

If you need to display the full 18-character Record ID as a column in your report, you can create a Formula field on the object:

1. Navigate to Setup and open the Object Manager for the relevant object (for example, Account or Contact).
2. Select Fields and Relationships, then click New.
3. Select Formula as the field type and click Next.
4. Give the field a label such as "18-Character Record ID" and set the return type to Text.
5. In the formula editor, enter the following formula: CASESAFEID(Id)
6. Save the field.
7. Add the new formula field as a column in your report to display the 18-character Record ID.