Building reports around the connection record using related lookup fields
A lot of the information you will want to get out of your data is about people who have volunteered. And that information will be found in the Connection Record.
You will want your primary object for certain kinds of reports to be the Connection object -- however when you go create the custom report type - you'll find the secondary objects aren't there! You COULD choose to build the report around the Contact object - but there's a better way.
You can get to fields you might not otherwise access, through the lookup fields that are in an object. And the Connections record is FILLED with lookups!
Let's say we wanted to get a report on all connections, that included the Volunteer Type, the Location name, and other fields from other objects.
Go to setup / app setup / Create / Report Types
Here you'll see all your existing report types - and be able to create a New Custom Report Type.
Click on New
We are going to create a New Custom Report Type based on the Connections Record as the Primary Object
Name this report "Connections with Lookups".
Make other settings as shown above.
We run into a problem however when we look for a secondary object to use with connections
Save the report type. We are not going to add any other objects. We'll use lookups to get the other fields we need!
Begin by editing the "Fields Available for Reports" section of the custom report type
The 43 fields that are part of a connections record are already in the layout
We can however also add fields that are accessible to the Connections record via lookups. To do this we click on the link that says "Add fields related via lookup"
Here we get a list of all the fields that have a 'lookup' connection to the connections object
Now select the fields in the contact record
The new fields appear in the available fields list and are marked with a looking glass symbol
The view list to the right now has views for "Connection Fields" and "Connection Fields (via lookup)
Select lookup again - and this time lookup items available through the Volunteer Opportunity Record
Let's grab one from the locations record as well. But how can we get to that?
From Occurrence we select location (which is a lookup from Occurrence) by clicking on "view related fields"
And now we can select "Location Name"
Optionally - you might organize the field layout by creating a new section for all your 'lookup fields"
Clicking on the new section button allows you to name a new section of the layout.
(This will determine where the fields appear in the 'field tray' when creating or customizing a report.
You can drag and drop fields and determine where they show up, and in which order.
You can also optionally click Edit Properties and determine which fields you want to have automatically on the report layout to begin with.
By checking this, the field STATUS will automatically appear on the layout when you create a new report.
You can set as many as you want as 'checked by default".
Click Save after you have completed customizing your report layout.