I am stumped on something that seems like it should be very simple to do.
I have a report which contains a subreport. If the subreport contains data, i want it to show on a new page, and if there is no data, i do not want a page break. I have tried putting page break controls at the beginning of the subreport, and I have also tried setting force new page to "before" in the subreport's heading. When the parent report is viewed, it refuses to page break.
I am using the Report_NoData event to set all the sections of the subreport to visible=false when there are no records.
Anyone know a simple fix for this?