Taking data from two doctypes in creating reports

I want to create a report that gathers data from two different doctypes. How could I do it? Also, how can I combine data from multiple fields in to one column.

This can be done using query report and do sql queries there.
Use a CONCAT() function or a ‘+’ operator to combine two or more strings together.