Taking data from two doctypes in creating reports

ERPNext Reports
, ,
1

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.

1 Like
2

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.

1 Like
3

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.