I have a report that is designed to exactly fit one page.
I have a sub-report (containing photos) that is at the bottom of the page. It prints on page 2 because there is no room on page one.
The problem is, if the record has no photos (no data for sub-report), the print report still prints a blank page.
Is there any way of saying "if the sub report has no data, change the margins, or just print the first page of the main report"?