# Union Module - Companies and Opportunities

**URL:** <https://community.spicecrm.io/t/union-module-companies-and-opportunities/518>\
**Category:** KReporter\
**Created:** [March 23, 2020, 11:54am UTC](https://community.spicecrm.io/t/union-module-companies-and-opportunities/518 "2020-03-23T11:54:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alberto](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Alberto](https://community.spicecrm.io/u/Alberto)\
**Post date:** [March 23, 2020, 11:54am UTC](https://community.spicecrm.io/t/union-module-companies-and-opportunities/518/1 "2020-03-23T11:54:35Z")

</div>

Hi,

I need a report thaht unions the companies module and opportunities module exist in the same report.  
How can i see how many and which companies converted by a single leads souce.  
For Example, with this view:  
Company: ABC 2  
VAT Number: 00000000000  
Leads source: Autogenerate

Thx  
Alberto

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [March 23, 2020, 4:31pm UTC](https://community.spicecrm.io/t/union-module-companies-and-opportunities/518/2 "2020-03-23T16:31:27Z")

</div>

Alberto,

if I understand your description correctly, you converted some leads to Account & Opportunity pairs and you would like to know which companies and opportunities where created on lead conversion per lead source.

The “lead source” you are refering to is in the lead itself.  
Assuming that you created 1 account with 1 opportunity for each lead, you may use Leads link to accounts and Opportunities to build you report.

Manipulate  
Select Accounts as starting module.  
Open the tree  
 ![grafik](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/9cd43bf0e0c9feaabbdef378c774223a0325cd68.png)  
Scroll down to Leads, Click “Leads”. Leads fields are loaded, drag and drop source field

 ![grafik](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/d0ffe38e9029b0744cbeceb0f8ab5da462d02a7a.png)

For Opportunity Data continue opening Leads tree, find Opportunities, then drag opportunity fields

 ![grafik](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/93ae497e2ab3cce59983f8ab70ff28d9a0f45778.png)

If you have KReporter PRO version you can select GroupedView presentation and set lead source as grouping field. A tree presentation would do as well.

If you want to be able to filter by lead source, drag the Accouns-\>Leads lead\_source in SELECT tab and make it editable.

Regards,  
Valérie