I have a report that displays account names and IDs, as well as the name and ID from the custom module records. There is a many-to-many relationship between the accounts and custom modules.
For some of the records in the report, I see the custom module data but not the related Account ID. However, when I open the custom module record in detail view, I can clearly see that there is a related account in the subpanel.
Why would I be able to see the related record in the detail view subpanel, but I can't see the account ID in the report?