This tutorial will walk you through how to create a report that meets the requirement of Accounts with Service Contracts. The goal is not to add any fields and to start from the Account object. Unfortunately, Salesforce does not support Accounts and Service Contracts together for a custom Report Type as of the day of writing, so we will use a joined report to get the same effect.
- Go to Setup –> Report Types –> Create new Custom Report Type
- Set the Primary Object to be Service Contract and fill out the rest as you want
- You do not need to select any additional related objects on the next screen
- Go to the layout, and the on the right select add from Lookup Field
- You are going to want to add pretty much any Account field that are you going to want to use, also make sure to include Account Name and ID, otherwise you can end up with an error message later in the process
- Go to reports, create a new report and select Accounts type
- Change the type of report to a Joined Report
- Add a block, and look for the Service Contract report
- If you did not bring in overlapping fields (I brought in all of the Account fields), you would get this error – keep adding account fields until this goes away
- Once you have added the block, you can update your filters and set your columns
- Make sure to Group by Account Name, otherwise it will look like the Contracts belong to a different account
If you do not need to do Accounts with and without Service Contracts, you can use the new Report Type you made and do Service Contracts with and without Accounts in a normal report using filters.
2 thoughts on “How to create a single Accounts and Service Contracts report”
I don’t have the Services Contract object as an option
Look then for the Contracts object, the Service Contract is added package if you need to use entitlements.