More specifically, I want to write a report using more than one "Primary Table". Can this be done?

We have done it internally but it was a struggle. If I had to do it over again, I would purchase a report from a report writer.

You can start by creating a report and using global calculated fields. Those will be a good starting point but you may have to make your own calculated fields to customize to your liking.