-
How to combine/join two reports - Lead History and Lead Activity History?
How to combine two reports? I have two report for Lead History and Lead Activity History. When I am trying to join these report I cannot find any common field. How can I resolve this?
Thanks
-
1 Reply
-
Hi Ajay,
This isn't going to be possible the way you defined it
Lead History report primary object is Lead History
Lead Activity History report primary object is Task (Activity)
Hence, no common object to joinBecause there is no common object, but a conceptual common Lead.Id, you might be better off writing a simple APEX VF controller and VF page to do the joins in memory into a single wrapper class. You'll need to think about what your layout is going to look like as for a given lead, there are n field histories and m activities
Thanks
Log In to reply.
Popular Salesforce Blogs
How To Use jQuery DataTable Plugin In Salesforce Lightning Component?
DataTables: "DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, build upon the foundations of progressive enhancement, that adds…
Latest Salesforce Commerce Cloud Feature: Lightning Order Management to Enhance the Order Management Process
If you are in the process of managing end-to-end order management in e-commerce or a product company, you would agree that it is the most…
What Slack and Salesforce Sales Cloud Could Do for Your Business
Today’s customers no longer prefer emails and phone calls. Customers anticipate continuous vendor assistance and participation. This means that reps must spend more time building…
Popular Salesforce Videos
Develop a Basic Slack App For Salesforce
Build Slack Apps integrated with Salesforce. Use Heroku to host Slack apps built using Slack Bolt Framework and get connected to Salesforce using Node.js library…
Level Up Your Processes With Google API and Salesforce Integration
Complex processes often span multiple systems. In this session, we'll cover how to integrate Google APIs into your Salesforce org with an API library in…
Apex Variables & Datatypes | Apex Basics | Salesforce Development Tutorials
In this video variables, datatypes, literals and identifiers in Apex language have been explained in detail . This video contains only the primitive datatypes in…
