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
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
0 helpful
1 reply
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies