How to make a custom Report view for a doctype

I’d like to enhance the Report view of a doctype by getting more details about the linked documents for each line.

To be clear: I have a doctype “Company”, a doctype “People”. All the companies have a CEO, that is a linked to People doctype. When I print the report view of the doctype Company, I can see the name of the CEO for each company, but I need to click on it to get information about him. I would like to print more details about each CEO (firstname, lastname, mail, …) for each company line.

It’s really easy to do with Query reports, I would like it to be possible through the report view… is it possible ?


Maybe research Script Report, that might give you ideas as to how to achieve it.