How to add the opportunity owner role to reports? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Deanna SaulsbyDeanna Saulsby 

How to add the opportunity owner role to reports?

I want to be able to filter reports by opportunity owner roles.
Steve MolisSteve Molis
 What kind of Report are you using?  The Opportunjty Owner(User)Role field is available in Opportunity Reports and filters.  

To limit the data shown in the report, you can set standard filters, field filters, filter logic, and row limits. Depending on your organization's setup, you may see additional filters, such as probability, hierarchy, territory, and others.
  • Use the Show drop-down to select your own, your team's, or all records.
  • Set time frame filters by choosing a Date Field and Range to view. Only records for that time frame are shown.
  • Use the Add menu to choose the type of filter to add. For example, click Add | Row Limit to set a maximum number of rows to display on a tabular report. By default, the Add button creates a field filter.
  • Hover over a filter to edit or remove it.

Field filters are available for reports, list views, workflow rules, and other areas of the application. For each filter set the field, operator, and value.

To enter filter criteria:
  1. Choose a field from the first drop-down list.
  2. Choose a filter operator.
  3. Enter a value in the third field and click OK.
  4. Optionally, click Add | Filter Logic to change the default AND relationship between each filter. This link is available in Professional, Enterprise, Unlimited, and Developer Editions in most places where filters exist, including reports and list views. See Filter Logic Tips.
  5. If you have Translation Workbench enabled, you can filter on translated strings by specifying the Filter Language for filter criteria that use containsdoes not contain, or starts with operators.
Deanna SaulsbyDeanna Saulsby
I am using Activities with Opportunities as the report type.  In the standard opportunity fields opportunity owner role is not a option.  Are there options to add opportunity owner role to the report field options?
Deanna SaulsbyDeanna Saulsby
<table class="htmlDetailElementTable" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr> <td> <div class="sfdc_richtext" id="questionDetailPage:ForumLayout:forumLayoutMasterComponent:forumLayoutMaster:askQuestion:answerRepeat:0:answerComponentInclude:comAnswerListItem:detailAnswerquestionDetailPage:ForumLayout:forumLayoutMasterComponent:forumLayoutMaster:askQuestion:answerRepeat:0:answerComponentInclude:comAnswerListItem:detailAnswer_00N30000006WEux_div">I am using Activities with Opportunities as the report type.&nbsp; In the standard opportunity fields opportunity owner role is not a option.&nbsp; Are there options to add opportunity owner role to the report field options?</div> </td> </tr> </tbody> </table> <script type="text/javascript">questionDetailPage__ForumLayout__forumLayoutMasterComponent__forumLayoutMaster__askQuestion__answerRepeat__0__answerComponentInclude__comAnswerListItem__detailAnswer = window.onload; window.onload=function() { if (questionDetailPage__ForumLayout__forumLayoutMasterComponent__forumLayoutMaster__askQuestion__answerRepeat__0__answerComponentInclude__comAnswerListItem__detailAnswer!= null) questionDetailPage__ForumLayout__forumLayoutMasterComponent__forumLayoutMaster__askQuestion__answerRepeat__0__answerComponentInclude__comAnswerListItem__detailAnswer();};</script>
Steve MolisSteve Molis
 Hi Deanna,
Okay you can't do that with a standard Activities with Opportunties report (but we ain't dead yet).  You can create a Custom Report Type (not a Custom Report)
https://help.salesforce.com/apex/HTViewHelpDoc?id=reports_report_type_setup.htm&language=en
and that should give you access to nearly all of the fields on the Opportunity Owner record.  
Let me know if you need any help.