Adding Hidden Field(s) to Reports

What shows in reports are selected fields. Oftentimes, there are additional fields that are hidden and need to be added by the Salesforce System Admin. For example, if you need to show "Opportunity Owner" on the XCPayoutDetails report you will want to do the following:

1. Go to SFDC > Build > Create > Report Types > Continue
2. Search "X" in the upper right corner for XCPayoutDetails > click "Edit Layout" under the "Fields Available for Reports" section
3. On the right side, select "Add fields related via lookup >>"
4. Select DealResultID > MeasureResultsID > Owner > Ok
5. The field will appear in the first section under "XCPayoutDetail"
6. Double click on the field name to rename it and clear out the "Display As". It will display as either "XCPayoutDetail: DealResultID: MeasureResultID: Owner". You can call it "Opportunity Owner" for example.
7. Once done, Save.
8. Then go back to Reports > XCPayoutDetails > Customize
9. Search "Opportunity Owner" and drag the field into the report > click Run Report to show the updated report.