joined report setup

Question

In my data model I have the opportunity object with a lookup to a custom object called tenant.

I have another custom object called subs that also has a lookup to tenant.

How can I create a report that for each opportunity it will list information from the subs where it has the tenant in common?

I've tried creating a joined report with the following report types but have had no luck

Thanks

Jenny B · Accepted Answer · 2015-06-03 19:38:01Z

1

You should create 2 custom report types:

This will let you use the parent Tenant Id or Name if unique to join to 2 reports together.

answered Jun 3, 2015 at 19:38

Jenny B

10.5k3 gold badges25 silver badges51 bronze badges

That worked perfectly - Thanks! Is there a way to limit the results of one block to where it has a common record?
– DNE
Jun 4, 2015 at 19:09
I was trying to think of an easy way to do that but off the top of my head I haven't been able to at least not without some type of not out of the box intervention.
– Jenny B
Jun 4, 2015 at 19:11

Add a comment |

1 Answer 1