Dear Sugar Colleague,

I have a topic with Reporting module, Professional Edition latest version.

I have, in the studio, added the fields - through relate - “organization” and “persons” to the opportunity’s. On the opportunity I can select a organization and a contacpersons. It is working fine.

But, I have a problem with the outcome of areport.

I have made a report with a starting point Opportunity. I want to report the opportunity including some fields of organization and Persons:

Opportunity => fields of the opportunity. It is working ok
Opportunity =>Organization=>Fields of “organization” => It is working ok
Opportunity =>Persons => Fields of Persons => remains totally empty. Whatever the Fields I select.

The relation of Opportunity and Persons are many to many. Also the relation of Opportunity and Organization is many to many. The added user is owner of this record. A person is connected to the opportunity,

Is this a know topic, has it to do something with the relations within the database?

Please help!

Regards, Edwin Best