-
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
Salesforce Trigger Example to count number of completed tasks in a single contact
Below is an example of how to use Salesforce Trigger to count number of completed tasks in a single contact trigger UpdateAccountNameFromContactLastName2 on Contact (before…
How to send an Email using Salesforce Marketing Cloud?
How to send an Email using Salesforce Marketing Cloud. Click on Content Click on Create Button which is on the right upper corner Creation Method (In…
The Fall of the Third Party Cookie: Here’s What Salesforce Pardot Users Need to Know
Marketers rely on cookies (the kind you cannot eat) to track visitor data and personalize marketing efforts. And like Cookie Monster love them. Google’s recent…
