Cosmetic Question about a Report...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a report from about 15 different queries - its a report that lists
all of an employees' system access, when the access was granted, when it was
removed, the system name, etc. (That's why so many queries).

Anyway, Because I needed so much information in one report, it would not let
me pull it all in with the wizard; I had to use subreports. That's fine, the
report works great except for cosmetically it leaves a blank space where a
subreport would be if that employee didn't have access to that particular
system. So even if an employee only has access to a few system, their report
is still 3 pages long with blank spots in it.

Does anyone know of any way to make it look better? I don't know of any way
to create this report besides using subreports...

Thanks all!
 
Duane,
What a simple solution that just went right over my head!! Thank you (and no
they were set to "no").

Much thanks!
 
OOPS another quick questions about that...it still actually creates 3 pages
though. So I tested it with someone who only had information in 4 tables, and
the 4 tables nicely compacted themselves on the 1st page (thank you!), but
there are still 3 pages. Do you know if that can be fixed?

Thanks,
Tanya Lee
 
You probably should also set the CanShrink property of the
section(s?) containing the subreports.
 
That was so obvious...sorry I even asked...but OBVIOUSLY I didn't think of
it. Thanks so much!! It worked perfectly.

Tanya Lee

Marshall Barton said:
You probably should also set the CanShrink property of the
section(s?) containing the subreports.
--
Marsh
MVP [MS Access]


Tanya said:
OOPS another quick questions about that...it still actually creates 3 pages
though. So I tested it with someone who only had information in 4 tables, and
the 4 tables nicely compacted themselves on the 1st page (thank you!), but
there are still 3 pages. Do you know if that can be fixed?
Click to expand...
Click to expand...
 
Back
Top