Print this page

Why is Product Family not available on custom report type 'Opportunity With Products'

Knowledge Article Number 000220290
Description Why is Product Family not available on custom report type 'Opportunity With Products'?
Resolution Product Family field needs to be added to layout. To test this and resolve please follow the steps below.

As a best practice, testing should be done in Sandbox or developer

1. Click on Setup | Build | Create | Report Types
2. Click on 'New Custom Report Type'
3. Select 'Opportunity' as Primary object
4. Name the Report as 'Opportunity with products'
5. Enter the description as 'Testing' or any name of your choice
6. Select Others from 'Store in Category' drop down
7. Select deployed
8. Click Next
9. In object relationship choose Products as Object B
10. Select Each "A" record must have atleast one related "B" record
11. Click Save

Navigate to Report Tab and check for the newly created report under Others folder
Open this report and you will find that 'Product Family' is not available as one of the fields

To add this field


1. Click on Setup | Build | Create | Report Types
2. Click on 'Opportunity with products' report
3. Scroll down and click on Edit Layout
4. On the right hand side window, select 'Product fields' from the drop down
5. Click on 'Add fields related via lookup'
6. In the popup box click on Products >> Price Book Entry >> Product
7. Check 'Product family' and click 'OK'
8. Click Save.

Product Family is now added to the custom report type




promote demote