Salesforce | How to combine/join two reports - Lead History and Lead Activity History? - Forcetalks

Tagged: Lead Activity History, Lead History, Report, Salesforce Apex Controller, Salesforce Visualforce Page, Task, Wrapper Class

Salesforce® Discussions

How to combine/join two reports – Lead History and Lead Activity History?

Posted by Ajay Prakash on April 30, 2016 at 10:28 AM

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

Suyash replied 10 years ago 2 Members · 1 Reply
1 Reply

Suyash

Member
April 30, 2016 at 10:39 AM

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 join

Because 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.