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.
for the data from two doctypes you can use the INNER JOIN in the query reports
and you can also use concat() to combine data in one coulmn.