...
Primary Object: Opportunities
Report Type Label: Opportunities with Maps and Stakeholders
Report Type Name: Opportunities_with_Maps_and_Stakeholders
Description: Opportunities with Maps and Stakeholders
Store in Category: Opportunities
Deployment Status: Deployed
Next
Click on (Click to relate another object)
Select ClosePlan and tick Each "A" record must have at least one related "B" record.
Click on (Click to relate another object)
Select CP: Deal Stakeholders and tick Each "B" record must have at least one related "C" record.
Save
...
‘Opportunities with/without SC Questions &
...
Answers’ and
...
‘Opportunities with Scorecard Questions and
...
Answers’
These Custom Report types will show reports with:
...
Click Save to save the layout.
Account Plan Scorecard Questions
...
w/wo Answers
...
and
...
Account Plan Scorecard Questions
...
with Answers
These report types show Account:
...
The difference between these Report Types is:
Opportunities with/without SC Questions & Account Plan Scorecard Questions w/wo Answers
Shows all Questions, answered or not
Opportunities with/without SC Questions & Account Plan Scorecard Questions with Answers
Shows only answered Questions
To create the 'the Account Plan Scorecard Questions w/wo Answers and the Account Plan Scorecard Questions with Answers' report type Report types:
Go to Setup > in the Quick Find box enter Report typesTypes > open it > click on New Custom Report Type
...
Then, create one or both of the Custom Report Types:
To create the Account Plan Scorecard Questions w/wo Answers Report Type
...
Primary Object: Accounts
Report Type Label: Account Plan Scorecard Questions with Answers
Report Type Name: AccountPlanScorecardQuestionsWithAnswers
Description: Accounts with Account Plan Scorecard Questions with or without Answers
Store in Category: Accounts & Contacts
Deployment Status: Deployed
Next
Click on (Click to relate another object)
Select CP Account Plans > Each “A” record must have at least one related “B” records
Select Scorecard Questions > Each “B” record must have at least one related “C” records
Select Answers > “C” records may or may not have related “D” records
Save
To create the Account Plan Scorecard Questions with Answers Report Type
...
Primary Object: Accounts
Report Type Label: Account Plan Scorecard Questions with Answers
Report Type Name: AccountPlanScorecardQuestionsWithAnswers
Description: Accounts with Account Plan Scorecard Questions and Answers
Store in Category: Accounts & Contacts
Deployment Status: Deployed
Next
...
Click on (Click to relate another object)
Select CP Account Plans > Each “A” record must have at least one related “B” records
Select Scorecard Questions > Each “B” record must have at least one related “C” records
Select Answers > “C” records may or may not have related “D” records Each "C" record must have at least one related "D" record.
Save
Add
...
Fields - Applies to both Report Types
This These Report type types will not include Scorecard Category Score % field. This field needs to be added to both Report Types via lookup.
To add this field:
Click Edit Layout
...
From View select Scorecard Questions Fields and hit Add fields related via lookup
...