Overview

This article will outline the steps to build a report with fields from multiple different objects. It will demonstrate how to create a report that shows the faculties under a session and the session times within a session, filtered by the course offering term. 

Steps

1. Identify Fields and Relationships: First, identify the fields you need and the relationships between their respective objects. In this article, we'll focus on the following objects:
   1. Course Offering: Used to filter by term.
   2. Session: Used to display all sessions.
   3. Session Time: Used to show the session times within a session.
   4. Session Connection: Used to show the related faculty under the session time
2. Create a Custom Report Type: Navigate to Setup > Report Types > Create a New Custom Report Type.
   1. In Step 1, select the primary object. For this report, the primary object will be the Course Offering since we'll use the term field in the course offering to filter and display sessions under it.
      
   2. Fill in all the required fields, change the status to Deployed, and click Next.
   3. In Step 2, add the related objects based on their relationships.
      
3. Create the Report: Once your custom report type is set up, go to Reports and create the report using the custom report type.
   1. Set Up the Filter Criteria
      1. In the report, set up the filter criteria to filter by the display term from the Course Offering.
      2. Add a filter to show only the Session Connection records where the faculty flag is checked. This ensures the report displays only the faculty members associated with the session times.
         
   2. Add Necessary Columns
      1. Add the columns needed to the report to display relevant information, such as faculty names, session times, and any other necessary details.
      2. Group the rows if needed. For example, this report groups the Course Offering by name, which will display the sessions under each course offering's course name. This can improve readability. You can skip this step if it is not necessary for your use case. 
         

These steps should help you create a simple report with fields from different objects. Keep in mind that the configuration may vary based on specific requirements.