-
Is it possible to make a cross filter report of Products?
Is it possible to make a cross filter report of Products? The Cross Filter option is greyed out.
-
6 Replies
-
Cross filter reports can only created for those objects that related child objects.
Most probably your 'Product' object don't have any child object and thus the filter is not available.Now if you are using a custom report, and the filter is not available, then the reason maybe the incorrect configuration.
Now there is an easy hack to check which object are related to your 'Product' object.Go to setup and in quick find search Schema builder.(Hint: Its in build tab)
Once there search your object, in case 'product', and click on the search icon next to product.
You will see you object box with all its fields. You will also see some lines going in and going out of the box. These lines represent which object is directly related to your product object, and if it have a one-to-one or one-to-many relationship.
So you will only be able to create reports with cross filter feature only for objects that are related to product objects.
Now if you find that there is a relationship and you still not able to see the cross filter report, and this most probably be happening in custom reports, then you may have to tweak you report settings a bit.
You can do that by going to setup->create->report types->(edit report type)
Hope this helps.
-
Thanks Mudit.
There are many custom objects that lookup to Product, and that Product looks up to. I specifically want to cross filter on OpportunityLineItem, but it is not available. I've tried changing the custom report type as well, but I don't believe it is possible for those two objects.
-
Hi Brian,
You can create cross object formula on product and OpportunityLineItem by selecting the standard report type i.e 'Opportunities with Products' at the time of "Create New Report".
When you create report by selecting report type than the Cross Filter option should not greyed out.
-
Yes Brian you are right that opportunity line item is not available in custom report type but if you want to create report of Products filter by opportunity line item fields then you can follow theses steps-
* Select report type "Opportunity with Products" and Create.
* Select "Summary format" and create grouping with Product and then Opportuniy Product so this will show
products with related Opportunity products.
* Add normal filter then in the picklist you can find opportunity product fields also.Note- But we can not apply filter on "Number of records" of OpportunityProducts related with Product.
-
Hi,
So you will only be able to create reports with cross filter feature only for objects that are related to product objects.
Now if you find that there is a relationship and you still not able to see the cross filter report, and this most probably be happening in custom reports,
Thanks
-
Hi,
Adding points relatted to it -
The report type should be Accounts with Activities (or with and without, whatever), and then you a cross-filter to filter for only Accounts without Opportunities.
Cross-Filters only work on the primary object, so there are many cases (like Activities with Accounts, or Contacts & Accounts where you need to create a Custom Report Type to get it to work properly).
Here is my Accounts with/without Activities report type, with a Cross-Filter to only bring back Accounts without Opportunities
Cross filters are only available when the report type is reporting on two different objects. The Activities with Accounts report is really only reporting on the activities object while referencing fields on accounts.
Hope this helps.
Log In to reply.
Popular Salesforce Blogs
Adopt Salesforce For Digital-First Funding Strategy in 2023
A digital-first funding strategy is a new approach to funding digital projects and initiatives. It provides early funding to support the development of new digital…
How To Process Large Records in Salesforce Without Hitting the Governor Limits
Batch Classes: - Batch Apex is exposed as an interface that must be implemented by the Salesforce developer. Batch jobs can be programmatically invoked at…
Dynamic Forms in Salesforce - Tips and Considerations
Designing user-centred, intuitive page layouts that display the right data at the right moment is the aim of dynamic forms. Over time, fields on data '…
