Report from multiple modules(user & Opportunity)

[brijeshcp@gmail.com]

How to create a report from multiple modules(user & Opportunity).

[tanya]

Hi,
you can show the values of related entities, if relationship type is one-to-many.
But report can have only one target Entity type

[brijeshcp@gmail.com]

Thanks for your reply.
Then how to make this report ? can i set One to Many Relationship for user and Opportunity entities.

[tanya]

For example you can create a list report for opportunity entity and add in columns Assigned User fields as well

[brijeshcp@gmail.com]

ok.
How to apply count() operation for getting Number of sales(Opportunity)

[tanya]

If you want to know, how many opportunities has a user, create a grid report for Opportunity, Group by Assigned User, Columns -> COUNT