I want to create a report that will contain a dozen subreports.
The 1st page of the report is filled up with information from the primary table for primary key 'ABC'.
Each subreport will contain data from a separate table for foreign-key 'ABC'
Sometimes, NONE of the other tables will have any data related to 'ABC'
There is no room in the Detail Section to drag a subreport without increasing the height size of the Detail Section. If I increase the height size of the detail section, then multiple pages will print for record 'ABC' regardless of whether the Subreports have anything to print.
I tried turning on 'Can Shrink' and 'Auto Height' for the main report Detail Section hoping either of these might solve the problem... but no joy.
How can I easily eliminate this challenge?