I need to construct report from multiple tables. How can I do it?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Konstantin

Konstantin

  • 0 Points

Posted 3 years ago

  • 0
  • 1
There is not a way to make a report from multiple tables.  But if the tables have a relationships, the typically you will lookup the  fields you need from the Parent records down to the child record and then do you reporting at the child level.
Photo of Avinash Sikenpore

Avinash Sikenpore

  • 162 Points 100 badge 2x thumb
Another way is to create a page which can have multiple reports to be viewed together.

Or like Mark Suggested - have a table with the common field from all the reports and populate the values. You can create report links and view them on a form as well.
Good point.  You can make a dashboard page and then there is a "Print this page", if you need to coax it into a single "document" like Word or a PDF or PPT