Help: Reports coming from multiple tables

  • Thread starter Thread starter Iconoclast
  • Start date Start date
I

Iconoclast

Pardon my ignorance but how do I generate a report that combines data from
multiple tables?
This is the scenario:
Tables:
Investor
Investment_1
Investment_2
Investment_3
....
Investment_N
1. The report should generate a page wherein the Investor's name appears and
some information coming from the various investment tables.
2. The investment tables cannot be combined into a single table since each
Investment table has different fields as that from the others. and
3. If the investor has no investment in a particular investment table then
the blank results must be suppressed from being printed.

Could anyone please give me a detailed procedure on this.
Thank you in advance.
 
I assume there is a relationship between Investor and the other tables. Base
your main report on Investor and create subreports based on the other
tables. Use the Link Master/Child properties to link the reports.
 
Back
Top