Is it possible for a report to use data from two unrelated tables?
I don't seem to finish understanding how reports work, or at least how to make them work in the way I need.
I developed a custom module with multiple tables, and what I need is a report which takes data from different queries to those tables and then produce a PDF. I understand how to do it for just 1 table.
In my ideal scenario I would create different queries to each table and then produce a report.
I don't seem to find a way to include in a report data from tables which have no relationship between them.
For example lets say I have a table for "Expenses" and another one for "Income". They don't have a common key between them. Is there any type of report I could use to produce a PDF with the query to both tables?
Thanks for any tip!