Multiple reports in one page?

[Samantha B.]

Hi,

My database has about 40 tables. I want to build a report that's really
multiple little reports, just arranged one after the other with no
whitespace in between. Each of my little reports is only about 8 lines long
and it looks pretty silly to have 40 pages when each one is mostly blank. I
can't seem to get this to work. Any suggestions?

TY!

 

[John Vinson]

Hi,

My database has about 40 tables. I want to build a report that's really
multiple little reports, just arranged one after the other with no
whitespace in between. Each of my little reports is only about 8 lines long
and it looks pretty silly to have 40 pages when each one is mostly blank. I
can't seem to get this to work. Any suggestions?

TY!

I wonder if your table design might not be at fault. Are these forty
tables identical in structure, just differing in data? If so, could
they not all be one table, with one additional field?

That said... you may be able to create a Report with forty Subreports,
all jammed together.

John W. Vinson[MVP]