Discussion Locked
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
How to access two or more tables
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
Question Unanswered
How can developers improve performance on content-heavy websites?
0 helpful
0 replies
Question Unanswered
How do you protect downloadable files on a WordPress store?
0 helpful
0 replies
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies