function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
GreenhornGreenhorn 

Creating report on opportunity with other custom object

Hi All,

 

I am trying to create a report  on opportunity object & one custom object

 

Custom objects 'custom_object' contains few stage names out of all opportunity stages.

 

To explain in SQL form, the query would be

 

Select * from opportunity where stageName in [select * from custom_object]

 

Opportunity & custom_object are not related.

 

Is it possible to have such report in salesforce reporting capability ?

 

Thanks in advance!

 

 

 

HariDineshHariDinesh

Hi,

 

I Don’t think you can Create Report with 2 objects which are not Related.

 

To create a report you need to choose the Report Type first.

For this you need to create one custom report type which will include objects (related objects).

But as per your description there is no relation between Custom Object and Opportunity.

In the Report type you don’t have option to choose these two objects.

So I don’t think you can create a Report and Report Type having these 2 Objects.