This guide will walk you through how to build a custom report type and use that custom report type to create a report for the uploaded Company Summary, Round Detail and Transaction records.
Create Custom Report Type
A custom report type allows you to include Company Summary, Round Detail and Transaction data into a single Salesforce report.
Please note: You should confirm if your client's Salesforce Org has not already created this custom report type.
In your Salesforce Setup:
- Type Report Type in the Quick Find box.
- Click Report Types.
- Click New Custom Report Type.
- Select Company Summaries in Primary Object picklist.
- Name the Report Type Schedule of Investments.
- Select Other Reports in Store in Category picklist.
- Select In Development under Deployment section.
- Click Next.
- Click on Click to relate another object.
- Relate to the Round Details.
- Relate to the Transactions.
- Relate to the Valuation Snapshots.
- Click Save.
Create Schedule of Investments Report
Now that we have created a custom report type, we will use this custom report type to create a new Salesforce report on the Company Summary, Round Detail and Transaction records.
From the Salesforce Reports tab:
- Click New Report.
- Type in Schedule of Investments in the search box.
- Click Schedule of Investments report type.
- Click Create.
In the Report creation page:
- Select All Company Summaries in the Show picklist.
- Select Snapshot Date in the Date picklist.
- Select This Month in the Range picklist.
- Type Date in the Fields search box.
- Drag the Transaction Date field under Transaction into the report.
- Drag the Fund Name field under Fund into the report.
- Drag the Company Summary Name field under Company Summary into the report.
- Drag the Current Shares field under Transactions into the report.
- Drag the Unrealized Value field under Valuation Snapshots into the report.
- Drag the Round field under Round Detail into the report.
Next, we will summarize the Current Cost and Unrealized Value fields.
Click the Dropdown arrow next to Current Cost.
Click Summarize this Field.
Select Sum.
Click Apply.
Repeat the same steps for Unrealized Value.
Next, we will group the report by Fund, Company Summary, and Round fields. Make sure to group the fields in this exact order.
- Click the Dropdown arrow next to Fund Name.
- Click Group by this Field.
- Next, group the Company Summary Name field.
- Lastly, group the Round field.
- Click Save As.
Name the report Schedule of Investments.
Select Aduro Reports (choose best folder preference) in the Report Folder picklist.
Click Save and Run Report.
You can now download the Salesforce report in excel format.
Click Printable View.
You have completed the steps to create a custom report type and create a Salesforce report for your uploaded Company Summary, Round Detail and Transaction records!