Discussion Locked

Access 97 Reports

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to produce one report by combining info from two tables in a one-to-many relationship. I used a Report with a subReport. When the record in the report has no related records in the subReport a large blank spave is printed where the subReport would have been printed. Is there any way to avoid this. Your info is truly appreciated. Thank You.

4 replies

by joat

In the the Properties for the Sub-Report while in the main report, mark 'can shrink' as Yes. This will allow the space used by the sub-report to be minimised.

by donq

ALWAYS manage database data through queries and only then format your Form, Report, or whatever.

Create and test a forward scrollong snapshot query based on the two tables containing the necessary data. You'll need to establish a working "link" before you get the necessary results which you can verify as correct BEFORE beginning your Report Formatting.

Once everything is produced correctly in the query format your report to group on a One Table Field and place Many Table Fields within the Detail section.

Good Luck - Don Quigg

by owentech

In addition to using the Can Shrink property, you can completely reduce the size of the subreport than use Can Grow

This discussion is closed to new replies.